Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Stharwani
Advocate I
Advocate I

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
Eric_Zhang
Employee
Employee

@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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.