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.
Dear Community,
Solved! Go to Solution.
To sort the months you can add a custom column to the 'Calendar table' in Power Query that will allow you to sort the [Month_Year_Short] column:
Text.From([Year]) & Text.PadStart(Text.From([Month_No]), 2, "0")
If you are needing to create a measure to dynamically look back 13 months I would suggest watching this video. It can be modified to 13 months https://www.youtube.com/watch?v=d8Rm7dwM6gc
To sort the months you can add a custom column to the 'Calendar table' in Power Query that will allow you to sort the [Month_Year_Short] column:
Text.From([Year]) & Text.PadStart(Text.From([Month_No]), 2, "0")
If you are needing to create a measure to dynamically look back 13 months I would suggest watching this video. It can be modified to 13 months https://www.youtube.com/watch?v=d8Rm7dwM6gc
Do you have a Calander or Dates table in your model. If so what columns do you have in it?
Hi, below a screenshot of the model.
In the matrix I use the "Month-Year-Short" field in the Calendar Table.
In the date filter I use the date key field from the Tine-Dim
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 |
---|---|
114 | |
99 | |
81 | |
70 | |
61 |
User | Count |
---|---|
148 | |
116 | |
104 | |
89 | |
65 |