Forum Discussion

LithanaM's avatar
LithanaM
Frequent Visitor
4 years ago
Solved

Conditional column in DAX using several lines

Dear community! I am always amazed by the support we can find there. Please let me first thank you all for your dedication in helping the beginners like me! I am trying to add a conditional column ...
Need Help
  • sevenhills's avatar
    sevenhills
    4 years ago

    Add a column and try this

    Column 1 = "Programme " & 
           if( 'Table'[Number of programs] = 1, " Unique", 
                   RANKX( 
                       filter('Table', 'Table'[Student] = EARLIER('Table'[Student]))
                       , 'Table'[Start Date],, asc
                    ) & "/ " & 'Table'[Number of programs]
            )

     

     

LithanaM's avatar
LithanaM
Frequent Visitor
4 years ago

Amazing! Thanks a lot!  I will look more into the new knowledge on RankX and EARLIER to better use it next time!

Have a great day!

Nathalie