Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I'm trying to sort the month into the proper sorting but it doesn't work as I search on the internet I found out that I must create an additional column and convert the month word into month number so I've created an additional column to convert the month word into month number. After converting it into numbers I tried to sort our sales by month number but an error occured. The error says.
"This column can't be sorted by a column that is already sorted directly or indirectly by this column"
Month Table
Please do note that the month table is related to the sales and forecast table.
Any help will be greatly appreciated. Thank You and God Bless.
Solved! Go to Solution.
Hi @Mikekhel1987,
There could be a loop. You can do it like this according to your table.
1. Add an index in the Query Editor.
2. Sort by another column.
Best Regards!
Dale
Hi @Mikekhel1987,
There could be a loop. You can do it like this according to your table.
1. Add an index in the Query Editor.
2. Sort by another column.
Best Regards!
Dale
Hi Dale,
Thank You for your help. It works just like magic. God Bless.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |