Forum Discussion

lekkerbek's avatar
lekkerbek
Helper IV
9 years ago
Solved

Adding budget

Hi everybody,   I have an excelsheet which I use to upload to Power BI. Values are added in columns I-L. I also added a column for the total budget for that year (column N).   If I upload this sh...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi lekkerbek,

     

    To simply resolve the issue above, I would suggest you to use the formula below to add a new calculate column to divide Budget by 4, then add this new created calcualte column as the target value on Gauge instead.

    Budget for Target = 'Your table Name'[Budget] / 4

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi lekkerbek,

 

To simply resolve the issue above, I would suggest you to use the formula below to add a new calculate column to divide Budget by 4, then add this new created calcualte column as the target value on Gauge instead.

Budget for Target = 'Your table Name'[Budget] / 4

 

Regards

  • lekkerbek's avatar
    lekkerbek
    Helper IV
    9 years ago

    So simple but effective.

     

    Slightly embarrassed, but grateful.

     

    Thanks and have a nice weekend.