Forum Discussion
Help me correct this DAX Sorting Column
I need help solving this formula. It is a sorting column Age bins Sort = SWITCH(TRUE(), 'Table'[Age Bins] = "0- 30 Days", "1", 'Table'[Age Bins] = "31- 60 Days", "2", 'T...
you can save the last condition, by changing it to:
Age bins Sort =SWITCH(TRUE(),'Table'[Age Bins] = "0- 30 Days","1",'Table'[Age Bins] = "31- 60 Days","2",'Table'[Age Bins] = "61- 90 Days","3","4")
you can save the last condition, by changing it to:
Age bins Sort =
SWITCH(TRUE(),
'Table'[Age Bins] = "0- 30 Days",
"1",
'Table'[Age Bins] = "31- 60 Days",
"2",
'Table'[Age Bins] = "61- 90 Days",
"3",
"4"
)
Works perfectly. Thanks.