cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Stharwani Regular Visitor
Regular Visitor

Rolling 12 months sum for inventory

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.

 Inv.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

Thanks

Sonali

1 REPLY 1
Moderator Eric_Zhang
Moderator

Re: Rolling 12 months sum for inventory

@Stharwani

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.