Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Variance Calculation Not Working (Error thinks there is text)

Good morning   Another newbie here...   I've started building some financial reporting dashboards in Power BI and want to show the actual vs forecast result for a given month, but when I insert a...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , You are trying to use sum on a text datatype. Please change the data type and try . Or change in power query

     

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , You are trying to use sum on a text datatype. Please change the data type and try . Or change in power query

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks for getting back to me. I forgot to mention that both fields used in the variance calculation are measures - the format section does say it is text but all options are greyed out so I can't change anything...

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      OK - I've got this working by adding value () around my measures used in the variance calculation after searching on why measures are formatted as text/how to change them.

       

      I couldn't find a definitive answer on why this was happening but it's solved now so thank you.