Forum Discussion
Bi-Directional tables in Excel using Power Query or ADX
Is there a way to make bi-directional tables in excel?? In one sheet there is a full table and in sheet two there is a filtered table. In the example below, the simple problem description is shown....
Alar,
may be this approach could be useful:
http://exceleratorbi.com.au/self-referencing-tables-power-query/
Hi,
Unfortunately no, this is not what I'm looking for.
Data is not populated in table 1.
But thank you for suggestion !