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”)
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]))
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.
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!