topic If statement with subtraction in DAX Commands and Tips

If statement with subtraction

SK1968 — Tue, 21 Jan 2025 10:25:49 GMT

Please can someone help with a problem I have

I have a table that has the following, Column 1 is 'Weekly hours', Column 2 is 'LA' - this is part of a calculated table called 'Hours Used'

I would like to produce a table/column - not sure which to say that if the lA is Plymouth then the weekly hours are to be subtracted from 12 and if not then the weekly hours need to be subtracted from 11

Any help would be much appreciated

Re: If statement with subtraction

bhanu_gautam — Tue, 21 Jan 2025 10:28:52 GMT

SK1968 You can create a new calculated column using DAX

DAX
Adjusted Hours =
IF(
'Hours Used'[LA] = "Plymouth",
12 - 'Hours Used'[Weekly hours],
11 - 'Hours Used'[Weekly hours]
)

Re: If statement with subtraction

SK1968 — Tue, 21 Jan 2025 12:08:11 GMT

Thank you very much for your help.

Maybe you could help me with another query. With the results of that calculated column it is not giving the correct total in a table visual.

Do you know why that would be?