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 have a slicer with dates, where I can select only one value.
Then I want to show a measure rolling year (12months before) for selected date and for date a year ago.
my table for slicer is date table and also I have my table with data and column "date" format.
Please help me to write how to choose these dates in filter. Many thanks
So, what you will want to do is to make sure that your date table is NOT related to your fact table. Use the date table for the slicer. Then, you will need to write a measure that gets the MAX of your date table and only returns a value if the current date is within your 12 month window, otherwise BLANK. Use the date from your fact table and measure in your visual.
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |