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 I am filtering this chart by last 12 months i.e. 24/11/2019- 23/11/2020. Is there any way how to start from 1/11/2019? I need it as a dynamic filter, so when we move to december it should do the same for December again.
Furthermore, I would like to know if it's possible to somehow use "MM" instead of "MMMM" in my chart. I am using CalendarAuto to generate this hierarchy.
Solved! Go to Solution.
Hi @Anonymous ,
According to your description, I created some data October 1, 2019 to December 5, 2020 to show
1. Create measure.
all_amount =
CALCULATE(SUM('Table'[amount]),FILTER('Table','Table'[Date]<=TODAY()&&'Table'[Date]>=DATE(YEAR(TODAY())-1,MONTH(TODAY()),1)))
2. Result.
Only data from November 1, 2019 to November 24, 2020 will appear
You can downloaded PBIX file from here.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
According to your description, I created some data October 1, 2019 to December 5, 2020 to show
1. Create measure.
all_amount =
CALCULATE(SUM('Table'[amount]),FILTER('Table','Table'[Date]<=TODAY()&&'Table'[Date]>=DATE(YEAR(TODAY())-1,MONTH(TODAY()),1)))
2. Result.
Only data from November 1, 2019 to November 24, 2020 will appear
You can downloaded PBIX file from here.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Of course you can start from the first of the month. Just use the EOMONTH function. Something like
EOMONTH( YourArchorDate, -13) + 1.
On your visual you can filter by relative date and only include items from the last 12 calendar months, which would limit the visual to include only 01/11/2019 - 31/10/2020.
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
@Anonymous , for MM you have create you own column and create custom hierarchy.
https://stoneridgesoftware.com/creating-hierarchies-in-power-bi/
https://www.youtube.com/watch?v=x6vXVJZ_eTY
First Ask is not very clear.
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 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |