Forum Discussion
filter table based on dynamic table
Hi, Im looking for a way to filter table (TargetTable) based on the data (FilterTable) that I can modify. So when I update outside of Power BI and then refresh it in PowerBi then the TargetTable is ...
Hi theo ，
When the data source is refreshed, the calculated table will also be refreshed, that is, a dynamic table.
From your description, you want to create a pivot table.
Here's a link about pivot table using dax, hope to help you:
https://community.powerbi.com/t5/Quick-Measures-Gallery/DAX-Unpivot/td-p/574832
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous Actually my problem is getting the right formula to refer to a table which be updated every now and then. I tried using relatedtable, but it only provide correct filter for the column that is directly has the relationship.
I dont see the pivoting will resolve it.
