Result based on 2 columns

[Anonymous]

Hi,

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

[amitchandak · Accepted solution]

@Anonymous , Try a new column like

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

Based on highlighted column

[FrankAT]

Hi @Anonymous ,

you can do it like this:

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

[BA_Pete · Accepted solution]

@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

[amitchandak · Accepted solution]

@Anonymous , Try a new column like

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

Based on highlighted column