Forum Discussion
Adding too measures together
Hello I'm creating a chart showing actual expenditure to date and future forecast. I've created two separate measures for: Cumulative payments to date Cumulative payments = var cont...
Thanks again for your reply.
Unfortunately that measure basically re-creates a line the same as the existing measure for Cumulative Forecasts.
I was hoping to get a line that starts from July thats show cumulative payments to date. For example, as at 31 December, the total cumulative figure for the first 6 months would be $1,000,000. The line would then change to Cumulative Forecasts where the January figure would be the $1,000,000 paid to date plus January forecasts. This would then continue on until 30 June.
See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008