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])
)
Ashish_Excel's avatar
Ashish_Excel
Solution Supplier
1 year ago

Hi,

Not sure of what you want but try these simpler measures

Sales_YTD_Advanced = CALCULATE(SUM('FactTable'[Value]),DATESYTD('Date'[Date]))
LY = CALCULATE([Amount],sameperiodlastyear('Date'[Date]))

If these do not work, then share the download link of the PBI file.  Show the expected result there clearly.