Multiple columns with multiple conditions

Question

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 Answer

Hi&nbsp;Anonymous
Create a calcuated column with DAX&nbsp;
Column =
SWITCH (
    [stage],
    "lead", [lead date],
    "salesQualify", [salesqualify date],
    "oppurtunity", [oppurtunity date],
    "customer", [customer date],
    "subscriber", [subcribe date]
)

&nbsp;
Best Regards
Maggie

Forum Discussion

Multiple columns with multiple conditions

1 Reply

Related content

Multiple conditions Index

Multiple Donut charts with conditions

Conditional Column with Multiple Conditions

MULTIPLE CARD

IF - Multiple conditions