Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
i Experts
I need your urgent help to design a graph using the below data.
ACTUAL | Predictive | ||||
ACCUMULATIVE COMPLETIONS | ACCUMULATIVE REQUESTS | REMAINING RECORDS | ACCUMULATIVE COMPLETIONS PREDICTIVE | ACCUMULATIVE REQUESTS PREDICTIVE | REMAINING RECORDS PREDICTIVE |
0 | 412920 | 412920 | 0 | 412920 | 412920 |
18785 | 420135 | 401350 | 18785 | 420135 | 401350 |
19257 | 437905 | 418648 | 19257 | 437905 | 418648 |
22628 | 448669 | 426041 | 22628 | 448669 | 426041 |
80623 | 457561 | 376938 | 80623 | 457561 | 376938 |
124425 | 491679 | 367254 | 124425 | 491679 | 367254 |
195085 | 498979 | 303894 | 195085 | 498979 | 303894 |
315085 | 513979 | 198894 | |||
435085 | 528979 | 93894 | |||
543979 | 543979 | 0 | |||
558979 | 558979 | 0 | |||
573979 | 573979 | 0 | |||
588979 | 588979 | 0 | |||
603979 | 603979 | 0 | |||
618979 | 618979 | 0 | |||
633979 | 633979 | 0 | |||
648979 | 648979 | 0 | |||
663979 | 663979 | 0 |
The non highlighted values are precalculated and will be static at all times. The date range starting from 201908 onwards for yellow highlighted.
The yellow color represent the predictive values, the calculation is somewhat like this,
3 columns
1/ Completions
2/ Requests
3/ Remaining
120,000 is a predictive value.
Completions( yellow color highlighted ), first value how its calculated
(Last month cumulative+ predictive ( 120,000) ) > request , then use request else completions
Requests
Last month cumulative + 120,000
Remaining
Request - Completions
Kindly assist me on how to calcuate the last month cumulative total and how to calculate rest of the months with predictive value?
Thanks in advance!
Hello @Anonymous
Are you able to share your .pbix file? The strucure of the model will determine the best way to answer your quesiton.
A good post on getting questions answered quickly by @Greg_Deckler
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |