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.

     

     

     

PBIDEV_10's avatar
PBIDEV_10
Helper II
4 years ago

FarhanAhmed : Thank you for your tip. It worked. But instead of month, I used date since user needs to drill down till day level. (Total members test = SUMX(VALUES(Calendar[Date]),[Total new members])). When I use it in the report then it takes lot of time to process the data than before. Can I do anything to load the data faster?