Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 natural months. Then I wanted to sort them in the right order (not alphabetically) so I created a column "num_month".
But when I click on "sort by column" I have this error message "You cannot sort this column by a column that is already sorted, directly or indirectly, by this column."
And I cannot add my "num_month" column in Power Querry because my table DimDate has been made with DAX so it doesn't appear in Power Querry.
Anyone know how can I sort my months by the order of "num_month" ?
Thank you very much.
Solved! Go to Solution.
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'
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Hi @DM_BI
what is your dax that creates the date table?
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Hi @DM_BI
afterwards how are you adding the calculated columns?
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
I added the following columns :
Día = DAY(DimDate[Date].[Date])
Anyone?
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'
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
75 | |
72 | |
39 | |
29 | |
27 |
User | Count |
---|---|
97 | |
96 | |
58 | |
44 | |
40 |