Forum Discussion

jianlong's avatar
jianlong
Resolver I
4 years ago
Solved

Create a dynamic table from two separate tables

File for test.pbix  Hi all,  Trying to find a simple solution for this  problem, hope you can share some ideas, thanks.   1) "All" table is the master key table  2) 1:many relationship to "A"-"E"...
Need Help
Tips and Tricks
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi jianlong ,

    By my test, the dynamic table expression can't be used in the INTERSECT or FILTER function as a table anyway, actually a calculated table/column cannot be dynamic, as they can only compute during data refresh.
    Best Regards,
    Community Support Team _ kalyj

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
4 years ago

Hi jianlong ,

By my test, the dynamic table expression can't be used in the INTERSECT or FILTER function as a table anyway, actually a calculated table/column cannot be dynamic, as they can only compute during data refresh.
Best Regards,
Community Support Team _ kalyj

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    4 years ago

    Hi jianlong ，

    You're welcome! If you don't have other problems, would you like to mark your reply as the solution. Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

     

    Best Regards,
    Community Support Team _ kalyj