Forum Discussion
Anonymous
6 years agoNot applicable
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...
Nathaniel_C
Community Champion
6 years agoHi Anonymous ,
Cumulative Actual = TOTALYTD('Becky - Upload'[Actual],'Date Table'[Date])
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Nathaniel_C
Community Champion
6 years agoHi Anonymous ,
Using my tables.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel