Forum Discussion
Solved
If statement with subtraction
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 wo...
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]
)
bhanu_gautam
Super User
Super UserSK1968 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]
)
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?