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 have two card visuals. First - Revenue CY, second - revenue LY YTD. I have also a year slicer.
If I filter on year 2018 they should show CY: Jan/1/2018 - March/3/2018, LY: Jan/1/2017 - March/3/2017.
BUT... if I filter on 2017 (or earlier) cards should show whole year, CY: Jan/1/2017 - Dec/31/2017, LY: Jan/1/2016 - Dec/31/2016.
I also want to show this data in a table (revenue by product and year/month).
Do you have any idea what to do?
Hi @AnetaK ,
Use TOTALYTD for First - Revenut CY
Use PREVIOUSYEAR for Second - revenut LY YTD
Bellow is syntax , Use Values(Your Year Column) to get selected value from slicer
=TOTALYTD(SUM(InternetSales_USD[SalesAmount_USD]),DateTime[DateKey], ALL(‘DateTime’), “6/30”)
=CALCULATE(SUM(InternetSales_USD[SalesAmount_USD]), PREVIOUSYEAR('DateTime'[DateKey]))
It doesn't work 😞
The LY measure shows value for whole 2017 not just two months.
Should I use Calendar[Date] column in the syntax?
Revenue LY = CALCULATE(SUM(PowerBI[Revenue]); PREVIOUSYEAR('Calendar'[Date]))
Hi @AnetaK,
If you can please share some sample data/pbix file for test.
It is hard to direct code dax formula based on your description without any detail information.
Regards,
Xiaoxin Sheng
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 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |