Forum Discussion
Dynamic Cumulative Sum based on Parameter Value
Hello, I'm working on a report in which we a testing a new calculation method for contribution margin. One of the tasks involve creating a measure to be included in both table and visual objects...
I'm a little confused. Are you saying that you want the measure to return the sum of a period defined as number of months before the current month, and not including the current month? So, today is 9/20, and a user selects 4, you want the measure to sum for the period of May 1st - August 31st?
You then mention "The current DAX measure is shown below and is returning the sum of the period 4 months prior to the comparison/current period. " Do you mean it's only returning the sum of May 1st to May 31st?