Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Thanks to the help here I am pretty close to what i'm planning to achieve.
The following calculated column measure has helped me
Solved! 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])))
@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])))
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |