Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I need help with forecast measure using power-bi Dax. from the below excel, at the end of the report, there is a constanct value 1.4, I need to use that constant value and forecast into future by subracting the last value with 1.4 and next row as previous row - 1.4 and so on until the value reaches 0.
Any help on how to get this using dax is really helpful
Year | Month | Day | WEEK ENDING DATE | waiter | |
2022 | April | 3 | 03/04/2022 | 3486 | |
2022 | April | 10 | 10/04/2022 | 3358 | |
2022 | April | 17 | 17/04/2022 | 3371 | |
2022 | April | 24 | 24/04/2022 | 3560 | |
2022 | May | 1 | 01/05/2022 | 3486 | |
2022 | May | 8 | 08/05/2022 | 3404 | |
2022 | May | 15 | 15/05/2022 | 3334 | |
2022 | May | 22 | 22/05/2022 | 3250 | |
2022 | May | 29 | 29/05/2022 | 3241 | |
2022 | June | 5 | 05/06/2022 | 3442 | |
2022 | June | 12 | 12/06/2022 | 3411 | |
2022 | June | 19 | 19/06/2022 | 3357 | |
2022 | June | 26 | 26/06/2022 | 3336 | |
2022 | July | 3 | 03/07/2022 | 3351 | |
2022 | July | 10 | 10/07/2022 | 3323 | |
2022 | July | 17 | 17/07/2022 | 3339 | |
2022 | July | 24 | 24/07/2022 | 3402 | |
2022 | July | 31 | 31/07/2022 | 3479 | |
2022 | August | 7 | 07/08/2022 | 3493 | |
2022 | August | 14 | 14/08/2022 | 3504 | |
2022 | August | 21 | 21/08/2022 | 3454 | |
2022 | August | 28 | 28/08/2022 | 3523 | |
2022 | September | 4 | 04/09/2022 | 3468 | |
2022 | September | 11 | 11/09/2022 | 3517 | |
2022 | September | 18 | 18/09/2022 | 3602 | |
2022 | September | 25 | 25/09/2022 | 3668 | 1.4 |
3666.6 | |||||
3665.2 | |||||
3663.8 | |||||
3662.4 | |||||
3661 | |||||
3659.6 |
Thanks
Priya
@LankaPriya , Assume you already have a date table with future date , assuming waiter is measure or create woth sum ot max
M1= calculate(lastnonblank(Table[Date]), allselected())
m2= calculate(lastnonblankvalue(Table[Date], [waiter Measure]) , allselected())
M3 =
if(Max(Date[Date]) <[M1] , [waiter Measure], [M2] * Power(1.4, quotient(datediff([M1],Max(Date[Date]), Day),7) ))
Hi Amit,
Thanks a lot for your immediate response.
I worked out the measures as below
I now want to subract the last value(937) - 1.4 and the resulting value(935.6) from 1.4 and so on and forecast
Thanks
Priya
Hello,
I further changed the measure as below
How can I change m3 to get as below
18-03-2023 = 935.6
19-03-2023 = 934.2
and so on
previous value - 1.4 in each step
Thanks
Priya
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |