Forum Discussion
Visualization in Power BI
I am new to Power BI but able to manage around few times. I am struggling to create cumulative of the data that I have. and some on time %. My file contains the following screenshot below. My visua...
Hi Dale,
On the below graph How automatically would I stop projecting once they have reached their last data point for the cumulative data.
The cumulative line should stop on Dec 2018. Please help
Here's the formula:
Forecast accumulated = CALCULATE(sum(Table1[Bidders List Approved - FORECAST]), FILTER(all('Calendar'[Date]), 'Calendar'[Date]<=max('Calendar'[Date])))
thanks