Forum Discussion

Chinh_Dac's avatar
Chinh_Dac
Frequent Visitor
3 years ago
Solved

Create Index Column Based on Month Year Column

Hi everyone I am new to DAX and I need some help. Please help me solve my problem. I have my calendar table, which includes a Month Year column. I want to create an Index column base on the Month Y...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Chinh_Dac ,

     

    Please check the formula:

    Column = RANKX('calendar',YEAR('calendar'[Date])*100+MONTH('calendar'[Date]),,ASC,Dense)

     

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Chinh_Dac ,

 

Please check the formula:

Column = RANKX('calendar',YEAR('calendar'[Date])*100+MONTH('calendar'[Date]),,ASC,Dense)

 

 

  • Chinh_Dac's avatar
    Chinh_Dac
    Frequent Visitor
    3 years ago

    Hi Jay,
    It works perfectly. Thank you so much for your help.