Forum Discussion
Excel Power Pivot Measure - 12 Month Sum DAX Incorrect
I am trying to create a measure that totals the past 12 months of revenue in Power Pivot. I have a date table and my data table linked. I created a Revenue measure that is calculating correctly R...
12 MTD Revenue:= var m = MAX('Data'[End Month]) return CALCULATE([Revenues],'Data'[End Month]>EDATE(m,-12))