Forum Discussion
DM_BI
Helper III
Helper IIIError when sorting by column (and table made with DAX language)
Hello, I created a DimDate (with a DAX formula calendar auto) and added natural months. Then I added a column "month_inter" because the start and end of my "month_inter" are very different from n...
Hi DM_BI,
you cannot sort mes inter by num because the value of num depends on mes inter.
Try to calculate your 'num' column the same way you calculate the 'mes inter' column but by assigning the month number instead of the month name. And then you can calculate the 'mes inter' based on the 'num' column. afterwards you should be able to sort 'mes inter' by 'num'
DM_BIHelper III
Helper IIIAnyone?
LivioLanzo
Solution Sage
Solution SageHi DM_BI,
you cannot sort mes inter by num because the value of num depends on mes inter.
Try to calculate your 'num' column the same way you calculate the 'mes inter' column but by assigning the month number instead of the month name. And then you can calculate the 'mes inter' based on the 'num' column. afterwards you should be able to sort 'mes inter' by 'num'
- DM_BI