Last answered:

30 Mar 2023

Posted on:

14 Nov 2022

1

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

  • Javascript
  • Python
  • Ruby
  • PHP
  • Java
  • C
  • C#
  • C++
  • HTML
  • SQL
  • R