Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Circular Dependency using Selectcolumns

Good morning community,   just wondering if you could help me with the following.   I have created a few calculated columns and the value is used as conditional formatting as per below.   ...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , When I do union ,

example

distinct(union(all(Table1[A]), All(TableB[A])))

 

In this case, if all values in column A of Table b is Unique then that will give an error when one create a relation between in new table and Table B A

 

Two avoid this

distinct(union(all(Table1[A]), distinct(TableB[A])))

 

so in you case , it might be like

distinct(union(Table1, distinct(selectcolumns(TableB,<> ,<> )))