Forum Discussion
1001
Resolver II
Resolver IIUnable to Filter Across Three Tables
Hi All, I have a series of tables, each connected through a common Unique ID Number. However, from the diagram below, I am trying to use a filter (Shelf Life) from my ZPLAN table to filter Products...
Thanks for your help all,
I ended up cheating, deciding to save the Existing Excel Pivot Table including related column formulass, as 'values only' to a new sheet as that day's date. Then I imported those daily files into PBI and consolidated them into one single table. Everyhting's now outputting as I need.
Cheers.
1001Resolver II
Resolver IISorry Pratyashasanal,
not working. I think the issue is I may have to create a unique Shelf Life number table that feeds into ZPLAN and use that as my filter. Will try that.
Thanks.