Prior Corresponding Period

[gbii1970]

I have a period in YYYYQn format (e.g. 2021Q1) coded in the SQL Server backend, with associated measures. How can I get the same measures from the corresponding period from the previous year from this using DAX?

Thanks!

[DataInsights · Accepted solution]

@gbii1970,

You can use the function SAMEPERIODLASTYEAR. Example:

Measure 1 LY = CALCULATE ( [Measure 1], SAMEPERIODLASTYEAR ( DimDate[Date] ) )

[v-xulin-mstf · Accepted solution]

Hi @gbii1970

You can try measure like:

= DATEADD(DateTime[DateKey],-1,year)  

= CALCULATE(SUM(ResellerSales_USD[SalesAmount_USD]), SAMEPERIODLASTYEAR(DateTime[DateKey]))  

For more information, you can refer:

SAMEPERIODLASTYEAR function (DAX) - DAX | Microsoft Docs

DATEADD function (DAX) - DAX | Microsoft Docs

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[DataInsights · Accepted solution]

@gbii1970,

You can use the function SAMEPERIODLASTYEAR. Example:

Measure 1 LY = CALCULATE ( [Measure 1], SAMEPERIODLASTYEAR ( DimDate[Date] ) )