Forum Discussion

NidhiBhusari's avatar
NidhiBhusari
Helper IV
4 years ago

Unable to get correct values using Time Intelligence functions

Hi Fam, I need to calculate YTD, QTD & MTD sales depending on the date selection done in the slicer. Also, I want to do calculations for the exact same time frame selected in the slicer. Steps ...
Need Help
Tips and Tricks
onurbmiguel_'s avatar
onurbmiguel_
Power Participant
4 years ago

Hi again, 

At least can you share your measure? 

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! ;-
Best Regards
BC

  • NidhiBhusari's avatar
    NidhiBhusari
    Helper IV
    4 years ago

    PY Sales --> CALCULATE(SUM(SALES), SAMEPERIODLASTYEAR(DATESYTD(CALENDAR(Date)))).
    CY Sales --> CALCULATE(SUM(SALES), DATESYTD(CALENDAR(Date)))