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.
Thanks Ashish.
The input data is shown below - 2 rows.
How do we split a 3 year duration contract into 3 years 2015, 2016, 2017 with a volume of 12 (36/3) each year?
Once we have that, then we can create a bar chart that shows years 2014 thru 2017.
Thanks,
Pav
| YEAR | FUEL PRODUCER | FUEL PURCHASER | TOTAL VOLUME ( MILLIONS OF LITERS) | DURATION OF AGREEMENT (YEARS) |
| 2014 | ABC | United Airlines | 10 | 1 |
| 2015 | PQR | Delta | 36 | 3
|
That is exactly what my solution does. See the file and the screenshot.
Excellent!!
Thank You!
Pav
You are welcome. If my reply helped, please mark it as Answer.