Forum Discussion

netanel's avatar
netanel
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

Diff % and money

Hello everyone
I am trying to write two formulas 
one That will bring me the change in percentages and one in money
I'm not getting the right numbers,
Would appreciate help
Attaches the formulas

 

1. Diff $ = CALCULATE(SUMX('Revenues DB','Revenues DB'[Net USD average per Day]-'Revenues DB'[Net USD average per Day LM]))
 
2. Net USD LM % difference from Net USD average per Day1 =
VAR __BASELINE_VALUE = [Net USD average per Day]
VAR __VALUE_TO_COMPARE = [Net USD average per Day for Budget 2021]
Var _Variance = if(ISBLANK(__VALUE_TO_COMPARE),0,__VALUE_TO_COMPARE - __BASELINE_VALUE)
RETURN
DIVIDE(_Variance, __BASELINE_VALUE)
  • amitchandak's avatar
    amitchandak
    4 years ago

    netanel ,

    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

    The two need to measures no column

     

    Diff $ = 'Revenues DB'[Net USD average per Day]-[Net USD average per Day LM]

     

    Try for a second one

     

    Net USD LM % difference from Net USD average per Day1 =
    VAR __BASELINE_VALUE = [Net USD average per Day]
    VAR __VALUE_TO_COMPARE = [Net USD average per Day for Budget 2021]
    RETURN
    DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE)

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    netanel ,

    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

    The two need to measures no column

     

    Diff $ = 'Revenues DB'[Net USD average per Day]-[Net USD average per Day LM]

     

    Try for a second one

     

    Net USD LM % difference from Net USD average per Day1 =
    VAR __BASELINE_VALUE = [Net USD average per Day]
    VAR __VALUE_TO_COMPARE = [Net USD average per Day for Budget 2021]
    RETURN
    DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE)