Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I'm looking for a bit of help, I'm trying to use a line graph to show This Year, Last Year, the year before and Budget, with a TD and then further figure. All of which is working fine, until I get to the Projection for the rest of this year. The way i want the Projection to work, is to first make a comparison of This Year vs Last Year-1 (because last year was a washout) over the last 4 weeks and then take the % growth and apply that to the further period for the year before. So in the example I've got, I've just stuck a manual % in to test out getting this to work, so I've put in that for the last 4 weeks we've been running at 90% of the year before, so therefore if we project out doing the same of ver the rest of the month, where does that get us to.
The problem i've got is that the formula instead of adding on the correct column wchich shoud be Bkgs TC Proj Calc, is seems to be, somehow just taking 90% off the cumulative total. So on 18th May it jumps from 122 bookings in the final column to 350, whereas the Projection suggests it should only jump to 130.
Here are my relevant formulas
Solved! Go to Solution.
Hi @LaurenceSD ,
You can refer the content in the following links to achieve it:
Cumulative Total/ Running Total in Power BI
DAX Cumulative for a filtered year and previous year
Cumulative total for current week, current month and current Year
Besides that, you can share some sample data in table PBI_BookingsSales (exclude sensitive data) with Text format in order to provide you a suitable solution. Thank you.
Best Regards
thanks @v-yiruan-msft I managed to find the solution, after a bit of time away from the report, was fairly simple in the end, my base calculation was wrong
Hi @LaurenceSD ,
You can refer the content in the following links to achieve it:
Cumulative Total/ Running Total in Power BI
DAX Cumulative for a filtered year and previous year
Cumulative total for current week, current month and current Year
Besides that, you can share some sample data in table PBI_BookingsSales (exclude sensitive data) with Text format in order to provide you a suitable solution. Thank you.
Best Regards
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |