"IF" condition based - Calculated column

Question

Hi Team,I have a scenario to achieve in DAX. The mentioned is the requirement.The Training "T1" should be mapped only to Role 1. If other Role contains the T1 value it should be "Null". Other values in Training can be same. Only for T1 we need to achieve this. Even if data has 100 roles, if any role contains T1 value then it should be "Null" all other values are similar.Please advice to achieve this output.Ahmedx&nbsp;

joebarry · Accepted Answer

Hi&nbsp;Arioli_Chezhian&nbsp;&nbsp;Add a new custom column&nbsp;&nbsp;Required Output = IF(Training[Name] &lt;&gt; "Role 1" &amp;&amp; Training[Trainings] = "T1", BLANK(), Training[Trainings])&nbsp;&nbsp;ThanksJoe&nbsp;If this post helps, then please Accept it as the solution&nbsp;

Forum Discussion

"IF" condition based - Calculated column

2 Replies

Related content

Unable to nest "if condition" activity in "for loop" activity in Data Pipeline

subtotal not work in metrics (value has "if" statement)

Calculating Cumulative Inventory with a Conditional "Reset to Zero" if Previous Month is Negative

Dynamic "IF" condition for calculated column

Return "Specific value" from table 1, if not found, return value from table 2