Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Subtracting Two Values

Hello all,   I am new to Power BI so I apoligize if this is an easy answer.   I need to subtract the values in one column from the values in another. I have written it as    (SUM(HR[Annual Rat...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    Anonymous try this

     

    SUM(HR[Annual Rate])-SUM('BY VP'[Annual Rate - Duplications])

    Would appreciate Kudos 🙂 if my solution helped. 

v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

hi  Anonymous 

From the scrennshot, there is a small mistake that a syntax error in the formula, just add ")" after HR[Annual Rate]

 

Please try this as parry2k provided:

 

Measure = SUM(HR[Annual Rate])-SUM('BY VP'[Annual Rate - Duplications])

 

 

Regards,

Lin

parry2k's avatar
parry2k
Super User
6 years ago

v-lili6-msft just curious how your solution is different than what I provided???