Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dynamic SAMEPERIODLASTYEAR with slider filter

Hello,

 

I'm strugeling wirth a issue in my powerbi inventory reporting.


My inventory number ("Flux" here) is a sum from the begining of my table.

With the Date ("DateDone" here) in a filter/slider, i can see the data of my inventory for a product at a specific period, but i would like to see also the inventory of this product at the same date for the last year.

 


With the dax formula "SAMEPERIODLASTYEAR"

LY FLUX = CALCULATE(SUM('odoo StockMove'[Flux]),SAMEPERIODLASTYEAR('odoo StockMove'[DateDone].[Date]))

the issue is that the date and the Flux sum returned is always the last date of the previous year

 

 

So for the 01/09/2021, the last year Flux ("LY Flux") will be the sum of the 31/12/2020, not the 01/09/2020

 


Can you help me with that please ?
Best regards

Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    4 years ago

    Hi Anonymous ,

     

    SAMEPERIODLASTYEAR is a time intelligence function,you'd better first create a calendar table then create a relationship between the date table and the fact table.

    Finally using below expression instead.

    LY FLUX = CALCULATE(SUM('odoo StockMove'[Flux]),SAMEPERIODLASTYEAR('Calendar'[Date]))

    Check below examples:

    https://databear.com/power-bi-dax-sameperiodlastyear-paralellperiod-and-dateadd/

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my reply as a solution!

2 Replies