I'm struggling to calculate a cumulative difference between two columns.
My dataset is a table that, for each month of the year, reports two values: "Sum of Requested orders" and "Sum of Confirmed orders".
Each sum is the amount of orders requested or confirmed in each month.
I would like to add another column, for each month, that calculates the difference between the two columns. This additional column however should also be comulative and sum the diffences for the whole year.
|Requested||Confirmed||**bleep** Difference||Requested||Confirmed||**bleep** Difference||Requested||Confirmed||**bleep** Difference||Requested||Confirmed||**bleep**. Difference|
I arrive to calculate the Difference in each month, but struggle to create the cumulative difference
any suggestion from the guru of DAX?