Forum Discussion
If statment between 2 dimensions table
Hi, I want to create a dax column with something like that : If Table1[ColumnA] = "Something", Then Table2[ColumnB], Else Table1[ColumnA] Table1 and 2 aren't related and can't be related....
Anonymous , You need to bring in the columnB in Table1 or columnA in Table2
In the New column in Table1
MAxx(filter(Table2, Table1[Key] = table2[Key]) , Table2[ColumnB])
amitchandak
Super User
Super UserAnonymous , You need to bring in the columnB in Table1 or columnA in Table2
In the New column in Table1
MAxx(filter(Table2, Table1[Key] = table2[Key]) , Table2[ColumnB])