topic Re: Diff % and money in DAX Commands and Tips

Diff % and money

netanel — Wed, 29 Sep 2021 05:39:40 GMT

Hello everyone!
I'm trying to make a simple difference formula
But the numbers are not correct for me ...
This is the formula

Net USD LM % difference from Net USD average per Day =

VAR __BASELINE_VALUE = [Net USD average per Day]

VAR __VALUE_TO_COMPARE = [Net USD average per Day LM]

RETURN

IF(

NOT ISBLANK(__VALUE_TO_COMPARE),

DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE)

)

Also attach a photo

Thanks all!

Re: Diff % and money

VahidDM — Wed, 29 Sep 2021 05:56:14 GMT

Hi netanel

Try this:

Net USD LM % difference from Net USD average per Day = VAR __BASELINE_VALUE = [Net USD average per Day] VAR __VALUE_TO_COMPARE = [Net USD average per Day LM] Var _Variance = if(ISBLANK(__VALUE_TO_COMPARE),0,__VALUE_TO_COMPARE - __BASELINE_VALUE) RETURN DIVIDE(_Variance, __BASELINE_VALUE)

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

Re: Diff % and money

netanel — Wed, 29 Sep 2021 06:20:21 GMT

Hi Thanks for the quick response,

something else if I want to get the result in dollars and not in percentages? I have tried this formula but it does not work for me.

Diff $ = CALCULATE(SUMX('Revenues DB','Revenues DB'[Net USD average per Day]-'Revenues DB'[Net USD average per Day LM]))

Re: Diff % and money

VahidDM — Wed, 29 Sep 2021 12:34:17 GMT

netanel

Try to use FORMAT DAX in your measure.

https://docs.microsoft.com/en-us/dax/format-function-dax

Appreciate your Kudos!!