Forum Discussion
Cumulative Total DAX
So, you've added another Cumulative Ext Qty Fails column to the pivot and made it a running total, which works great. The problem is I have a Cumulative Ext DPM column which will take the Cumulative Ext Qty Fails/Cumulative Exp Shipments*1000000 for each month. Any idea how to accomodate that if I get rid it?
Right now, i have another DAX formula for the Cumulative DPM that uses the Cumulative Extr Qty Fails:
Cumulative Extr DPM:=([Cumulative Extr Qty Fails]/[Cumulative Exp Shipments])*1000000
Maybe i'm making this way harder than it should be.
As far as this new question...
What is Cumulative Exp Shimpments? It was not included in the sample data?
Ah, i see what you did. However, I want the value for 2016-05 Cumulative Extr Qty Fails (highlighted in yellow) to be 911.392 and not 0.
This is my only question. Sorry for confusion.
All I really did was just modify the Measure which sums the values in [Sum of Ext Qty] column - nothing else
That zero is from the sample data you posted - I included it in the Matrix just to compare - I have not created any columns