Forum Discussion
Cumulative YTD total
Hello – I am new to power BI/Query and am trying to create my first dashboard. I have a simple set of data with 4 columns – date, customer, actual amount, and planned amount. I also create a dat...
Anonymous
Try this.
Cumulative Actual = CALCULATE(SUM('Becky - Upload'[Actual]),FILTER(ALL('Becky - Upload'),'Becky - Upload'[Date]<=MAX(''Date Table'[Date])))
Let us know if it works.