Forum Discussion
Helper IIDAX calulation help for identifying blank values
Hi EmilyM2019 ,
Go to Power Query, go to Add Column tab, Conditional Column and add along the lines below. You can put in multiple statements.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Helper IIYou could also do an added column in the modeling tab (not in Power Query) using DAX like this:
New Marker =
IF(
OR(TableName[CaseCategory] = "Performance", TableName[CaseCategory] = "Contract") = TRUE,
"Yes",
TableName[Marker])
This simply checks to see if the Case Category is one of the two values required. If so, it returns "Yes". If not, it defaults to whatever the current Marker is.
If you want to do it in the Query Editor, you can do as Nathaniel suggested and then merge the columns to get a single value.
Community ChampionHi JonV ,
However, less of a performance hit when you use Power Query over a calculated column.
Nathaniel