If statement with subtraction

[SK1968]

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

[bhanu_gautam · Accepted solution]

@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]
)

[SK1968]

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?