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 would like to create a table showing monthly data and YTD data at the same time.
I want to put a month slicer so that monthly data can change based on month selection in the filter but YTD being unchanged.
I created two calendar; 1.All months and 2 YTD months.
(Max date for YTD is defined here)
From DB, I calculate the value in smaller scale (/1000) = "mValue"
And my further steps to arrive at YTD
1. Calculate YTD value using TOTALYTD with Calendar dates (Defined period)
2. Define Year in YTD value to arrive at "CYTD" and "PYTD"
3. In filter, I put months from 1. All month Calendar as below.
How can I fix the YTD figures so that it does not move along with the month filteration I have ?
Hi, Thanks for the tips.
Where exactly should I enter the REMOVEFILTERS() ?
use REMOVEFILTERS()
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 |
---|---|
13 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
22 | |
3 | |
2 | |
2 | |
2 |