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 this using DAX?

 

Thanks!

Need Help

2 Replies

  • DataInsights's avatar
    DataInsights
    Super User
    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
    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!