Forum Discussion
gwright15
Helper I
7 years agoInventory Days - Count back method
Hello I'm looking to calculate the inventory days of each product line, using the count back method. So for example, if i have 1000 units in stock, a bought 300, 30 days ago, 500, 50 days ago...
amitchandak
Super User
7 years agoCheck This
https://community.powerbi.com/t5/Desktop/Cumulative-Total/td-p/43115
Also running total in quick measures
gwright15
Helper I
7 years agoThanks for this. My running total seems to be working okay.
The element i'm struggling with is to ascertain which date the running total gets breached.
I've tried using LASTNONBLANK but doesn't seems to be working.