Updating tabular models for Ordinal property in calculation groups
If you created a Tabular model using one of the preview versions (CTP, RC, …) of Analysis Services 2019, you don’t have the final structure for the Ordinal attribute that Microsoft defined in the final version of compatibility level 1500.
A calculation group is like a table in the Tabular model and a calculation item is a value in a column of the table defined for the calculation group. In order to sort the calculation item there is an additional column called Ordinal used to manage the “Sort by Column” behavior, like any other column of a Tabular model. Even though the Ordinal column is not mandatory, it is required in order to make the custom ordering work – without the column Ordinal, the calculation item will be displayed in in alphabetical sort order regardless of the Ordinal property of the calculation item.