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]),

    ALLSELECTED('Date'[Month])

)

 

I have another measure to calculate Last year values for selected months as follows:

 

LY = CALCULATE([Amount],DATEADD('Date'[Date],-1,YEAR),REMOVEFILTERS('Date'[Date]))

 

All i need is to have a YTD measure for Last year (LY) measure.

 

REgards  

 

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])
)

3 Replies

  • 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

  • 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.