Forum Discussion
BenHoward
Helper I
Helper Icreate new table using a measure as a filter
I have two tables Table 1 and Table2 which are unrelated, and by using a measure which I build up from a selection of values from Table1, I want to build a 3rd table which is a subset, ie a filter, o...
In the first line, you said Table1 & Table2 are unrelated. But still trying to filter the values of Table2 based on Table1.
Can you share sample data for the tables that you have and the output you are expecting?
BenHowardHelper I
Helper I<Update>
After a few hours work I have managed to create the table I needed using Power Query
</>
Alas not, the example I supplied is a much simpler version of the use case where I create a measure based upon a selection from 2 unrelated tables, which then provides the input for the filter which is applied to a third unrelated table.