Forum Discussion

Waseem's avatar
Waseem
Helper III
1 year ago
Solved

YTD Values for Last year Measure

Dear Community    I have a measure to calculate YTD values, which is derived as follows:   Sales_YTD_Advanced = CALCULATE(     SUM('FactTable'[Value]),     DATESYTD('Date'[Date]),     ALLSELE...
Need Help
  • mh2587's avatar
    mh2587
    1 year ago
    Sales_LY_YTD = //try this
CALCULATE(
    [Amount],
    DATESYTD(DATEADD('Date'[Date], -1, YEAR)),
    ALLSELECTED('Date'[Month])
)
mh2587's avatar
mh2587
Super User
1 year ago
Sales_LY_YTD = //try this
CALCULATE(
    [Amount],
    DATESYTD(DATEADD('Date'[Date], -1, YEAR)),
    ALLSELECTED('Date'[Month])
)
Waseem's avatar
Waseem
Helper III
1 year ago

It worked like a champ. Many thanks