Forum Discussion
Conditional Column Based on the Values In Multiple Columns
Hi Everyone, How can I create a conditional column either in Power query or in dax based on values in multiple columns? Table1: Exemption data Student ID Student Name English Maths S...
Anonymous Couple different ways. You could do this in DAX using a fairly complex calculated column to do LOOKUPVALUE or MAXX(FILTER(...),...). Or, you could unpivot your first table's last three columns, create a composite key of ID and Subject in both tables and then the problem is trivial in DAX or you could even do a Merge at that point in Power Query.
It's easy you can use "and" in the power query
= each if [column_1] = "value1" and [column_2] = "value1" then "Other" else null)