Same period Last Year 1,2,3,4, MTD/QTD/YTD

[Rohit1]

Hi ,

Please find attached file , i need similar measure for Year-2,-3,-4,-5 and QTD/MTD. How can i do.
EDNA Clarification 21052022.xlsx (104.1 KB)
Could not upload pbix as it is very heavy

Regards

[Heather]

Here are some previous solutions that have been presented in the forum for a similar issue:

DAX Calculate dyanamic measure to compare YoY in graphic chart

Hi @judy_fmf PFB solution for your requirement. I’m just showing past 3years data. If you want you can change the Variable PY. 3Y Same period = VAR SM = SELECTEDVALUE ( ‘Dates Disconnected’[MonthName] ) VAR SY = SELECTEDVALUE ( ‘Dates Disconnected’[Year] ) VAR PY = 3 VAR Sameperiod = FILTER ( Dates, ( Dates[Year] > SY - PY && Dates[Year] <= SY ) && Dates[MonthName] = SM ) RETURN CALCULATE ( [Total Sales], Sameperiod ) [3Y SamePeriod]

SamePeriodLastYear returns this year selecte period value

Try using DATEADD instead of SAMEPERIODLASTYEAR. Here is one of Sam’s videos that explains this concept. [The DATEADD Function - The Best and Most Versatile Time Intelligence Function in DAX] [Enterprise%20DNA%20Expert%20-%20Small]

Compare to periods Without Time Intelligence Function

Hi @HosseinVossoughi, Think you might be referring to offsets. If so, this might be the content you where looking for. i hope this is helpful. [Using The Extended Date Table - OFFSETS In Power BI]

[Rohit1]

Thanks.

Regards.