Forum Discussion

LoriBKS's avatar
LoriBKS
New Member
2 years ago

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! 

 

 

 

Need Help

2 Replies

  • parry2k's avatar
    parry2k
    Super User
    2 years ago

    LoriBKS what are the criteria? You have to provide the business logic to create the new column?

  • Kaviraj11's avatar
    Kaviraj11
    Solution Sage
    2 years ago

    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!