Forum Discussion
Solved
DAX Question - Interesting
Hello All, I have an Interesting question – In my data, I have fuel producer, fuel purchaser, contract start date, contract duration, and total volume for the contract duration. How do I show a b...
Hi,
Please find attached the PBI file.
Hope this helps.
PavB what is the expected output? Is that total volume equally distributed to all the agreement years? Provide details that help to answer the question, without the business logic, not sure how one can assist. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Hi Parry,
Expected output is below.
| Year | FUEL PRODUCER | FUEL PURCHASER | TOTAL VOLUME ( MILLIONS OF LITERS) | DURATION OF AGREEMENT (YEARS) |
| 2014 | ABC | United Airlines | 10 | 1 |
| 2015 | PQR | Delta | 12 | 3 |
| 2016 | PQR | Delta | 12 | 3 |
| 2017 | PQR | Delta | 12 | 3
|
We divide the total fuel volume with the duration of the contract, and add records for each successive year for that producer and purchaser for the avg fuel per year.
I hope this helps.
Thanks,
Pav