Forum Discussion

gbii1970's avatar
gbii1970
Regular Visitor
5 years ago
Solved

Prior Corresponding Period

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 thi...
Need Help
  • DataInsights's avatar
    DataInsights
    5 years ago

    gbii1970,

     

    You can use the function SAMEPERIODLASTYEAR. Example:

     

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

     

  • v-xulin-mstf's avatar
    v-xulin-mstf
    5 years ago

    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!

v-xulin-mstf's avatar
v-xulin-mstf
Community Support
5 years ago

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!