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 

Try changing the "Data Type: variant" to decimal number.

 

If you can't do it in the measure formatting options, make sure your columns you are refrencing in the measures for the calculations are formatted as decimal numbers.

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi PaulDBrown ,

Unable to change the data type from Variant as few are having $ format and few don't. I have checked from lowest calculating columns and measures. I have changed them from General to Decimal Number still its the same error.