How to use a dynamically choosen date value for a YTD year-over-year comparison?

[Anonymous]

I want to use dynamically chosen Month # and Day # from a Fact table (or from the Date dimension table) for the YTD year-over-year comparison. For example, if the chosen date value is 2019-11-05 (or the chosen Month # = 11 and Day # = 5), I want to do the comparison like:

• (20150101 - 20151105) vs (20160101 - 20161105) vs (20170101 - 20171105) vs (20180101 - 20181105) vs (20190101 - 20191105)
  
  

How should I do? Use Slicer for the selection? DATESYTD()? TotalYTD()?

[v-yuta-msft]

@Anonymous ,

Generally, you may create a measure using dax like pattern below:

Result =
VAR Current_Year =
    YEAR ( Table[Date] )
RETURN
    CALCULATE (
        SUM ( Table[Value] ),
        FILTER (
            ALLEXCEPT ( Table, Table[Date].[Year] ),
            Table[Date]
                <= DATE ( Current_Year, SELECTEDVALUE ( Date[Month] ), SELECTEDVALUE ( Date[Day] ) )
        )
    )

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

If you have them choose a date in the slicer, you can use DAY to get the day and MONTH to get the month. Not sure I understand your question.