Forum Discussion

SpiroswayGR's avatar
SpiroswayGR
Icon for Resolver III rankResolver III
5 years ago

System Date / between filter for 2 different years

Dear all,   I am trying to create 2 measures to calculate revenue for 2 different years. 1st : CY Revenue  = CALCULATE(SUMX (revenue(field) , filters ) this is correct 2nd : PLY (previews last ye...
Need Help
iXpert_info's avatar
iXpert_info
Icon for Helper II rankHelper II
5 years ago

Hey SpiroswayGR 

If you have a Date Dimension table then just try below measure for PLY
PLY (previews last year = calculate (CY revenue ,date[Year]=year(today())-2 )

This seems to be working in my case where I had the similar scenario.

Did I answer your question? If yes please mark this as solution

Best Regards
Jay Patel
iXpert Analytics

SpiroswayGR's avatar
SpiroswayGR
Icon for Resolver III rankResolver III
5 years ago

iXpert_info 

I have the same metrics but is not working.

The problem is on "system date" filter.

(Working with Hotel Data)

I have 2 dates : 1st calendar date that connect with hotel date.

2nd System date that is the pc date that one reservation imported.

 

I am calculating revenue with that way for CY and PLY correctly but when i filter / slicer with system date working only for CY. 

For example : I want to filter system date only january 2021 and i want my PLY calculation to filrted with same filter but for january of 2019.