Forum Discussion

JorgeAbiad's avatar
JorgeAbiad
Icon for Helper III rankHelper III
6 years ago
Solved

Insert Date Field in the Market Data table

Hello PBI experts,   I have a requirement to create probably bar/line chart show the budget and forecast values for each year starting from 2020 up to 2039. But the budget and forecast for each yea...
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi JorgeAbiad ,

     

    We can use pivot to meet your requirement

     

    1. Select All the budget and current fc columns, then pivot them

     

    2. Replace the  “Current FC" with "Current_FC" to make split more easier

     

    3. Split Attribute column with space

     

     

     
    If it doesn't meet your requirement, Could you please show the exact expected result based on the Tables that you have shared.
     


    Best regards,

     

JorgeAbiad's avatar
JorgeAbiad
Icon for Helper III rankHelper III
6 years ago

Hello v-lid-msft 

Thank you very much!

I was able to do it. However, that leads me to another requirement now. How am I going to create a line  chart to show the budget and current forecast for each year(2020 - 2036)? Or this even possible? Do I need to calculte the budget and forecast for each year?

 

Regards,

JorgeAbiad

 

  • JorgeAbiad's avatar
    JorgeAbiad
    Icon for Helper III rankHelper III
    6 years ago

    Hello  v-lid-msft,

     

    Thank you for all the support you have provided so far.

    I have a new requirement which I think seems to be a bit complex. In the matrix below, there are years when there is data for the budget. The deviation for each year between budget and forecast is required. 

    I'm not sure if the simple Current Forecast - Budget will do the correct calculation considering there are null values in the Budget row. My question is how to get the correct deviation or difference>