Forum Discussion

PavB's avatar
PavB
Frequent Visitor
2 years ago
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...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

Please find attached the PBI file.

Hope this helps.

 

PavBidani's avatar
PavBidani
Helper II
2 years ago

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

YEARFUEL PRODUCERFUEL PURCHASERTOTAL VOLUME ( MILLIONS OF LITERS)DURATION OF AGREEMENT (YEARS)
2014ABCUnited Airlines101
2015PQRDelta36

3

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    That is exactly what my solution does.  See the file and the screenshot.

    • PavBidani's avatar
      PavBidani
      Helper II
      2 years ago

      Excellent!!

      Thank You!

      Pav

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        2 years ago

        You are welcome.  If my reply helped, please mark it as Answer.

  • PavBidani's avatar
    PavBidani
    Helper II
    2 years ago

    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