I have my data like this (image below)
Now i need to create a line chart in Power BI. I am getting something like this (sample image below)
Just for illustration i used this chart (Target and Actuals are two lines).
Now i need the lines to be cumulative over months. How can i do that in Power BI?
Go to Solution.
You may download my PBI file from here.
Hope this helps.
thanks that fixed it using DATESYTD, but why wouldn't the other method work?
You are welcome. If my previous reply helped, please mark that as Answer. You were simply not using the correct function.
Check out the on demand sessions that are available now!
Check out the Winners!
Features releasing from October 2020 through March 2021