Multiple columns with multiple conditions

[Anonymous]

i have the following table with column names stage, lead date, salesqualify date, oppurtunity date, customer date, subscribe date only

how to get output column?

want output column using dax or power query.

.

stage	lead date	salesqualify date	oppurtunity date	customer date	subcribe date	output
lead	12-01-2018	12-06-2018	null			12-01-2018
salesQualify	null	12-01-2018	null	null	null	12-01-2018
oppurtunity	null	null	12-01-2018	null	null	12-01-2018
customer	null	12-05-2018	null	12-06-2018	null	12-06-2018
subscriber	null	null	null	null	12-08-2018	12-08-2018

if the stage column have lead, return lead date as a output column

if the stage column have salesqualifty, return salesqualify date as a output column

if the stage column have oppurtunity, return oppurtunity date as a output column,etc

[v-juanli-msft · Accepted solution]

Hi @Anonymous

Create a calcuated column with DAX 

Column =
SWITCH (
    [stage],
    "lead", [lead date],
    "salesQualify", [salesqualify date],
    "oppurtunity", [oppurtunity date],
    "customer", [customer date],
    "subscriber", [subcribe date]
)

Best Regards

Maggie