Hi all,
I am trying to calculate rolling 12 month sum fo rmy inventory. Following up the posts in teh community I have tried
CALCULATE([Inventory], DATESINPERIOD('Date'[Date],LASTDATE('Date'[Date]),-12,MONTH))
But it just returns the same result as Inventory. I'll appreciate any help.
Thanks
Sonali
Could you please post your data model and relationship? Even better you can upload a sample pbix.
By the way, check if this thread helps.
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
User | Count |
---|---|
214 | |
54 | |
46 | |
41 | |
41 |
User | Count |
---|---|
278 | |
210 | |
73 | |
73 | |
65 |