Forum Discussion

Arioli_Chezhian's avatar
Arioli_Chezhian
Icon for Helper II rankHelper II
3 years ago

DAX - Calculated column based on IF condition

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". ...
General Comments
Need Help
Tips and Tricks
AnthonyGenovese's avatar
AnthonyGenovese
Icon for Resolver III rankResolver III
3 years ago

I would do something like this for a caluclated column

 

IF(AND('TableName'[Trainings]="T1", NOT('TableName'[Name]="Role 1")),BLANK(),'TableName'[Trainings])

 

If this post was helpful, please kudos or accept the answer as a solution.
~ Anthony Genovese
Need more PBI help? PM me for affordable, dedicated training or consultant recomendations!