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 created a waterfall chart associated with a period slicer.
I want to compare data YTD for 2018 and YTD for 2019. As you can see it takes full year turnover for 2018.
How can I compare YTD 2018 and YTD 2019 with a DAX measure?
Here : from 2018-01-01 to 2018-01-03 and 2019-01-01 to 2019-01-03
Thanks
[Base Measure YTD LY] = // year-to-date last year
CALCULATE(
[Base Measure],
SAMEPERIODLASTYEAR(
DATESYTD( Calendar[Date] )
)
)
Best
D
Hello,
Thank you for your answer, but this measure only gives last year's turnover.
I would like to select a period, and if the period is between 2018-01-02 and 2019-01-05 the cascade will display :
- in the 2018 bar -> sum of turnover between 2018-01-02 and 2018-01-05
- in the 2019 bar -> sum of turnover between 2019-01-02 and 2019-01-05
If too complicated only YTD turnover for 2018 until 2018-01-05 and YTD for 2019 until 2019-01-05.
How can I get this result?
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |