Forum Discussion

PBIDEV_10's avatar
PBIDEV_10
Helper II
4 years ago
Solved

YTD calculation issue

Hello experts! I have a calculation for new members where it says till 31.05.2021(CutOverDate) read value from source 2 else from source 1 (Total new members = IF(MAX(Calendar[Date])>= [CutOverDate]...
Need Help
  • FarhanAhmed's avatar
    FarhanAhmed
    4 years ago

    I think first You should create a New intermediate measure to calculate the correct calculation for totals.

    Total  Members = 
SUMX(VALUES(Dates[Month & Year]),[Total new members])

     

    Now, this measure should be used in YTD measure to get correct YTD numbers.

     

     

     

amitchandak's avatar
amitchandak
Super User
4 years ago

PBIDEV_10 make sure calendar is marked as date table and you are using year, month, and month name from calendar table

PBIDEV_10's avatar
PBIDEV_10
Helper II
4 years ago

amitchandak Yes. Calendar is marked as a date table and I am using year, month from the same table.