Subtracting Two Values

[Anonymous]

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 Rate]-SUM('BY VP'[Annual Rate - Duplications])))

but I get the error: "The SUM function only accepts a column reference as an argument."

Not sure exactly what this means, any help is appreciated

@edhans 

Thanks in advance

[v-lili6-msft]

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]

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

[parry2k · Accepted solution]

@Anonymous try this

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

Would appreciate Kudos 🙂 if my solution helped. 

[Anonymous]

Thank you!