Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

check if value exists in multiple columns

Hi Guys,   Need your help on powerbi desktop please.    I am trying to workout a calculation to check mutiple column status for each row; if any of the column has 1 or more "Expired" status, in t...
Need Help
  • Thejeswar's avatar
    Thejeswar
    3 years ago

    Hi Anonymous ,

    You can use the below DAX

    Result = IF('Table'[Status1] = "Expired" || 'Table'[Status2] = "Expired" || 'Table'[Status3] = "Expired" || 'Table'[Status4] = "Expired" || 'Table'[Status5] = "Expired", "Expired", "Valid")

    Output will be as shown below

     

Thejeswar's avatar
Thejeswar
Super User
3 years ago

Hi Anonymous ,

You can use the below DAX

Result = IF('Table'[Status1] = "Expired" || 'Table'[Status2] = "Expired" || 'Table'[Status3] = "Expired" || 'Table'[Status4] = "Expired" || 'Table'[Status5] = "Expired", "Expired", "Valid")

Output will be as shown below