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
|
Any time a duration is > 1 year, we need to create additional records in our data set to show yearly volume.
So when we have 2015, 36 million volume, 3 years duration we create 3 records,
2015 , 12, 3
2016, 12, 3
2017, 12, 3
Regards,
Pav