Microsoft Business Central - Inventory value over time

Hi AndySmith 
If I understood you correctly, this is running total of 3 months.

Take a look at the linked discussion:
https://community.fabric.microsoft.com/t5/Desktop/Cumulative-Total-of-a-Measure-for-last-3-months/td-p/2526540

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

Hi,

Create a Clendar Table with calculated column formulas for Year, Month name and Month number.  Sort the Month name column by the Month number.  Ceate a relationship (Many to One and Single) from the Date column of the Item table to the Date column of the Calendar Table.  To a slicer, drag Year and Month name and make a selection.  This measure pattern should work

Measure = calculate([Inventory_value],datesbetween(calendar[Date],edate(min(calendar[date]),-35),max(calendar[date])))

Hope this helps.