Forum Discussion
Projected Revenue Based on Average Per Day
Needs a disconnected calendar table, and you will need to consider how to display the individual projects.
Note: This should normally be done via LINESTX.
I've only just had chance to properly look at what you have created and it exactly what I'm after! Thank you so much for taking the time to help me.
I have a single selection filter to show each project one by one (I never need to see them all together).
I've tried to recreate your work but the Actuals RT and Forecast RT measures are coming back blank.
All I've done is create the disconnected Calendar table with the same DAX as you then created Actuals RT and Forecast RT with the same DAX as you. There are no errors showing, they are just blank. Have I missed something?
You can use EVALUATEANDLOG to figure out where your results differ from mine. Or provide a different set of sample data
Hi again,
I've tried to understand why I can't get my data to match yours but I'm really struggling so I've anonymised my actual report and attached here Power BI Help
I would also like a "cost" line which is permanently across the chart (as it looks now) but that increases each month as the monthly costs are added on to the upfront cost. Basically, I would like this chart to show me when the projected is due to hit the cost line and then how much it increases after that.
Thanks so much for the help so far - I'm doing this in addition to my day job so it's slow going!