Last answered:

30 Mar 2023

Posted on:

14 Nov 2022

0

Can we sort the country column ?

Can we sort the country column alphabetically, as we had done for month name in the previous videos

1 answers ( 0 marked as helpful)
Posted on:

30 Mar 2023

0

Yes, you can.  Use this DAX formula :

SortedTerritory = 
RANKX(dim_SalesTeritory, [SalesTerritoryRegion], , ASC, Dense)

But Dimitar didn't follow the alphabetical order, he customized it

Submit an answer