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.
Hello everyone,
I have a calculated column to group days to 12 months as shown below.
In the matrix, colomn [Month Group] functions as Columns. Logically, the colum in the matrix should be ranked from 1M to 12 M. However, the colum shows the order as 1M, 10 M, 11M, 12M, then 2M to 9M.
Any ideas to arrange the column from 1M to 12M?
Thank you.
Dennis
Solved! Go to Solution.
@12Bowers12 in Power Query, create a Conditional Column that applies the same logic as the Month Group column but give it a value starting at 1 through to 12... Ensure it's a whole number and then when you Close & Apply, you can use the new column as the Sort by Column over the Month Group column.
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
Hi @12Bowers12
Create one more calculated column as
Month Group = CEILING( Loss[Days Claim]/30, 1 ) & " M"
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Month Group = CEILING( Loss[Days Claim]/30, 1 ) & " M"
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Thank you, CNENFRNL.
Thank both of you, the two solutions work perfectly.
@CNENFRNL This is awesome! Tried to ❤ but only had 👍 available lol
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
Hi @12Bowers12
Create one more calculated column as
@12Bowers12 in Power Query, create a Conditional Column that applies the same logic as the Month Group column but give it a value starting at 1 through to 12... Ensure it's a whole number and then when you Close & Apply, you can use the new column as the Sort by Column over the Month Group column.
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
@12Bowers12 can you use "Days Claim" value to sort "Month Group" which is under the Column Tools ribbon (the "Sort by Column" button)?
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
Thank you, TheoC,
The message 'Sprt by another column' says:
We can't sort the 'Months Claim' column by 'Days Claim'. There can't be more than one value in 'Days Claim' for the same value in 'Months Claim'.
Any ideas?
Dennis
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 |
---|---|
108 | |
97 | |
79 | |
67 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |