Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

Result based on 2 columns

Hi, I need to create a custom Categeory = "BA" and "Place" ="" then "BA" else "".

amitchandak
5 years ago
Anonymous , Try a new column like

if(not(isblank([Categeory])) && isblank([Place]), [Categeory], blank())

Based on highlighted column
BA_Pete
5 years ago
Anonymous

In Power Query, you would create a custom column as follows:

requiredColumn = if [Categeory] <> null and [Place] = null then [Categeory] else null

amitchandak has already provided the best DAX solution.

Pete

Super User

5 years ago

Anonymous , Try a new column like

if(not(isblank([Categeory])) && isblank([Place]), [Categeory], blank())

Based on highlighted column