Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Error on Subtracting two measures having format

Hi PaulDBrown  and @all, Here is one more Issue i am facing. I think you can fix this.  Continuing to the link below. https://community.powerbi.com/t5/Desktop/sign-currency-for-only-few-rows-bas...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi Anonymous ,

     

    We can try to use the following measure to meet your requirement:

     

    Change =
VALUE (
    SUBSTITUTE (
        [January Total] & "",
        "$",
        ""
    )
)
    - VALUE (
        SUBSTITUTE (
            [February Total] & "",
            "$",
            ""
        )
    )

     

    If it does not work, could you please share the formula of [Janury Total] and [February Total] if it does not contain any confidential information?


    Best regards,

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi santiagomur ,

Thanks for reply. I have checked with calculating columns and measures. All of them are set to Decimal Number.

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous 

 

Are you using the function FORMAT in any of the columns or measures?

The error you are getting is saying that somewhere along the calculation line you have a non-number value(s)

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    January and February measures have both have format PaulDBrown 

    • PaulDBrown's avatar
      PaulDBrown
      Icon for Community Champion rankCommunity Champion
      6 years ago

      Anonymous 

      by "format" do you mean you are using the Function FORMAT( ) ?

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        yes PaulDBrown