Forum Discussion
IF Statement using Text Column
Hello, I want to use an IF Statement on a text column to return certain values/calculations from another column. For example, If Column 'Name' = "New" then Calculate(Total_Value*12) else (T...
Anonymous , It would be like this:-
Value = SWITCH ( TRUE (), MAX ( 'Value Table'[Name] ) = "New", [Total_Value] * 12, MAX ( 'Value Table'[Name] ) = "Old", [Total_Value] / 12, [Total Value] )
Hi Samarth_18
Thank you for this, it works perfectly!
One further question if that is ok... is it also possible to have two IF statements in this Measure?
For example -
If Column 'Name' = "New" then Calculate(Total_Value*12)
or
If Column 'Name' = "Old" then Calculate(Total_Value/12)
else (Total_Value)
Thank you for your speedy reply and help 🙂
Samarth_18
Community Champion
Community ChampionAnonymous , It would be like this:-
Value =
SWITCH (
TRUE (),
MAX ( 'Value Table'[Name] ) = "New", [Total_Value] * 12,
MAX ( 'Value Table'[Name] ) = "Old", [Total_Value] / 12,
[Total Value]
)Super Samarth_18
This works perfect... I must try to learn more about the SWITCH function!
Thank you for your help! 🙂