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

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)