Forum Discussion

dexter2424's avatar
dexter2424
Icon for Helper I rankHelper I
5 years ago
Solved

Cumulative SamePeriodLastYear by category

Hi,  I'm facing an issue in the last 3 days. I thought I can solve it, but no luck.    I have a measure with LY Amount:   LY Amount = CALCULATE([CY Amount],SAMEPERIODLASTYEAR(vw_Prem_ToO_ID[D...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    dexter2424 , Not very clear. Have to try formula like?

    YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))
    Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))

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

dexter2424 , Not very clear. Have to try formula like?

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))
Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))

dexter2424's avatar
dexter2424
Icon for Helper I rankHelper I
5 years ago

No, I have missed this, but helped me a lot! 

Thank You!