Forum Discussion

kennoe's avatar
kennoe
Helper I
7 years ago
Solved

Calculating value from table values

I have created a table and need a formula to calculate the values in a vacant column. The relevant columns in the table are shown below. I want to calculate the Variance, which is the the difference ...
Need Help
  • kennoe's avatar
    kennoe
    7 years ago

    Thanks Thejeswar

     

    I am happy with the result. We round the variance value to a whole number, so it will be 0% in this case, which is what would be expected.

     

    Cheers

     

Thejeswar's avatar
Thejeswar
Super User
7 years ago

Hi kennoe,

It will be easier to assist if you can share the PBIX file with such a scenario present.

 

It will save a lot of time involved with re-creating the scenario from our side to satisfy your requirement

  • kennoe's avatar
    kennoe
    Helper I
    7 years ago

    I appreciate your help on this matter but I am not in a position to share the PBIX file.

    I take that the solution is not a simple matter of a formula that uses the values in the table?

     

    Thanks

    Steve