Thanks to the help here I am pretty close to what i'm planning to achieve.
The following calculated column measure has helped me
Go to Solution.
@rhys1987, try how
Actual cumulative quantity ?CALCULATE(SUMX(Assignment,Assignment[Assignment Quantity]),FILTER(Allocation,Allocation[PDE] a EARLIER(Allocation[PDE]) && Allocation,Allocation[DC] ? EARLIER(Allocation[DC]) && Allocation[Index]<- EARLIER(Allocation[Index])))
Proud to be a Super User!
View solution in original post
Thanks!First one works, i was doing something similar but couldn't quite see it.
Hi , @rhys1987
Could you please tell me whether your problem has been solved?If it is, please mark the helpful replies or add your reply as Answered to close this thread.More people will learn new things here. If you haven't, please feel free to ask.
Best Regards,Community Support Team _ Eason
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.