LY YTD complicated version

[AnetaK]

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?

[BalaVenuGopal]

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]))

[AnetaK]

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]))

[Anonymous]

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