Forum Discussion
NMC20
1 year agoHelper I
Projected Revenue Based on Average Per Day
I have managed to get an [Average Sales Per Day] in my data set, along with [Days Until Project End] and, based on those two fields, [Total Projected Reveue] for the project. However, I was hopi...
lbendlin
1 year agoSuper User
You can use EVALUATEANDLOG to figure out where your results differ from mine. Or provide a different set of sample data
NMC20
1 year agoHelper I
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!