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

Thanks for reply PaulDBrown 

The calculation used for Change are measures [January Total] and [February Total] which have the same data type as shown in below screenshot.

 Change = [January Total] - [February Total] 

Still results in same error.  Is there any thing else I am missing ?

santiagomur's avatar
santiagomur
Icon for Resolver II rankResolver II
6 years ago

i think some of the columns you use to calculate january total or february total is txt or some are date and other numeric. 

  • 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.

    • santiagomur's avatar
      santiagomur
      Icon for Resolver II rankResolver II
      6 years ago

      try use Jantotal=values(column)   FebTot=Values(column)       dif=[JanTotal]-[FebTotal]

    • 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