Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to replace values in joined columns from different tables?

Hello   I have used a common column to join three tables.   I dragged the common column to create a table in the dashboard. Then I need to do these:   1) I want to drag another column into the ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago
    Use switch function.
    Follow switch function dax for more number of column.

    Thanks
    Pravin
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Create column in 2nd table

 

NEw column=if(related(table3[Column]="Yes","New",table3[Column])

 

For first question,

 

I think we need to use lookupvalue or simply merge two queries.

Could you please share sample dataset and expected output.

 

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.