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,

     

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 

      • v-lid-msft's avatar
        v-lid-msft
        Icon for Community Support rankCommunity Support
        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,