Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Creating a column based on another columns values

Hello! I'm trying to see if this is even possible with DAX. My goal is to create the 3rd column "Matched_ID".
  • -If there's value in "ID" but not in "AccountID", then take value in ID column, or vice versa.
  • Also, if there's vales in both "ID" or "AccountID" columns, take the value in AccountID column.
Would this be achievable using DAX? I tried using RELATED function but wasn't able to achieve it.. any help would be appreciated!
 
IDAccountIDMatched_ID
100 100
 20002000
33399999999
Need Help

1 Reply

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion
    4 years ago

    NewStep=Table.AddColumn(PreviousStepName,"Matched_ID",each [AccountID]??[ID])