Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 (Total_Value)
I haven't been able to figure out how to do this.
I tried this but get an error for Max function only accepts a column reference as an argument
Solved! Go to Solution.
@GB08 , 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]
)
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Hi @GB08 ,
Ideal code what your trying would be like this:-
Value = IF(MAX('Value Table'[Name])="New",[Total_Value]*12,[Total Value])
I am considering [Total_value] as some already created measure.
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
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 🙂
@GB08 , 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]
)
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Super @Samarth_18
This works perfect... I must try to learn more about the SWITCH function!
Thank you for your help! 🙂
User | Count |
---|---|
98 | |
91 | |
84 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |