Forum Discussion

droupa's avatar
droupa
Frequent Visitor
7 years ago

Help with PY Comparative

Hi,   I am trying to compare PY revenue on reservations/booking data, but I want to exclude all the reservations that were booked within in year of the current date of the report being run. This is...
Need Help
TeigeGao's avatar
TeigeGao
Solution Sage
7 years ago

HI droupa ,

PLease try to use the following DAX query:

PY YTD Total Revenue = sumx(
filter('Calendar','Calendar'[Date]<[Booking date PY]),[PY Total Revenue]
)

Based on my test, we'd better not using multiple date column in this scenario.

Best Regards,

Teige