Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
How to transform the month to show in "MMM" (Jan, Feb) abbreviations and show the corresponding year in the x-axis?
Thanks.
Solved! Go to Solution.
you can use FORMAT(date,"mmm")
https://learn.microsoft.com/en-us/dax/format-function-dax?wt.mc_id=DP-MVP-5004616
Proud to be a Super User!
Additionally, create a Calendar Table.
Additionally, create a Calendar Table.
you can use FORMAT(date,"mmm")
https://learn.microsoft.com/en-us/dax/format-function-dax?wt.mc_id=DP-MVP-5004616
Proud to be a Super User!
After create to "MMM" format, how to sort the month in correct order?
create a number column like 202401, 202402, 202403.
=year(date)*100+month(date)
then sort the month name column by the number column
Proud to be a Super User!
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |