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
For 1 st question.
Create column in first table
Col=If(isblank(related(table2[col2])),"yes")

2nd que
If(isblank(related(table2[col2])),"no",related(table3[col]))

Thanks
Pravin


Anonymous's avatar
Anonymous
Not applicable
6 years ago
Thanks for this, but can we do it if I need to make 20 replacements? I cannot do a nested IF formula with 20 entries.
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    Use switch function.
    Follow switch function dax for more number of column.

    Thanks
    Pravin