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.
Sort z-A gives this
Not sure how do I fix this, can someone please advise.
Solved! Go to Solution.
HI @sraj
Add another column with this code:
MonthDay NO. = FORMAT([Date],"MMdd")
then sort your Month Day column with MonthDay NO.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
Ok, that worked..I think I understood it wrong but tried the sorting of the column with the new column you suggested and that worked. Awesome!! Thank you very much!!
HI @sraj
Add another column with this code:
MonthDay NO. = FORMAT([Date],"MMdd")
then sort your Month Day column with MonthDay NO.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
@VahidDM - Do you mind helping again? After I made that I saw that if I run it for the last 4 months that includes Dec 2021, this goes after the Jan 2022 & Feb 2022. So I updated the Month day no with the year
Can you share your PBIX file (after removing sensetive data)?
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |