Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Multiple columns with multiple conditions

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 o...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    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

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

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