Forum Discussion

NickProp28's avatar
NickProp28
Icon for Post Partisan rankPost Partisan
5 years ago
Solved

YTD, MTD and variance

Dear Community,    Good day! Here is my raw data with YTD andLYTD measure. TotalYTD = TOTALYTD(SUM(CP[Value]),'Calendar'[Date]) TotalLYTD = CALCULATE([TotalYTD],SAMEPERIODLASTYEAR('Cale...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    NickProp28 , The number is correct for YTD. Maybe you need MTD vs Last year MTD

     

    TotalLYTD = TOTALMTD(SUM(CP[Value]),dateadd('Calendar'[Date],-1,year))

    TotalYTD = TOTALYTD(SUM(CP[Value]),'Calendar'[Date])

     

    Please find the file, The YTD values are correct. If you need only MTD, use the MTD formula

     

    MTD is not added to the file

     

NickProp28's avatar
NickProp28
Icon for Post Partisan rankPost Partisan
5 years ago

Dear amitchandak ,

 

Here's the sample pbix: https://ufile.io/9ihptdbq

What I looking for is when I filtered on months 'Feb' and year '2020', the card should show current in '4165.80' while past year is '2178.80'. 
Appreciate your help. 

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

NickProp28 , The number is correct for YTD. Maybe you need MTD vs Last year MTD

 

TotalLYTD = TOTALMTD(SUM(CP[Value]),dateadd('Calendar'[Date],-1,year))

TotalYTD = TOTALYTD(SUM(CP[Value]),'Calendar'[Date])

 

Please find the file, The YTD values are correct. If you need only MTD, use the MTD formula

 

MTD is not added to the file