Forum Discussion
DAX Formula Help
Looking for DAX help in creating the Result column as a new colum in my main data set using the 2 sets of criteria. Thanks!
Assuming one of the conditon is
If Criteria1='Outage' AND Criteria2='PM' THEN Result should be 'Outage'
Calculated Column:
Result
=
SWITCH(TRUE(),
'TableName'[Criteria1]="Outage" && 'TableName'[Criteria2]="PM" ,"Outage",
'TableName'[Criteria1]="Outage" && 'TableName'[Criteria2]="False" ,"Outage",
'TableName'[Criteria1]="TBD" && 'TableName'[Criteria2]="PM" ,"PM",
'TableName'[Criteria1]="TBD" && 'TableName'[Criteria2]="False" ,"RTS",
BLANK()
)
You can add the condition accordingly. Hope this helps!