"IF" condition based - Calculated column

[Arioli_Chezhian]

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 

[Ahmedx]

please consider Accepting it as the solution

https://community.fabric.microsoft.com/t5/Desktop/Dynamic-quot-IF-quot-condition-for-calculated-colu...

[JoeBarry · Accepted solution]

Hi @Arioli_Chezhian 

Add a new custom column 

Required Output = IF(Training[Name] <> "Role 1" && Training[Trainings] = "T1", BLANK(), Training[Trainings])

 Thanks

Joe

If this post helps, then please Accept it as the solution