Forum Discussion

1001's avatar
1001
Icon for Resolver II rankResolver II
3 years ago
Solved

Unable 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...
Need Help
  • 1001's avatar
    1001
    3 years ago

    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.     

pratyashasamal's avatar
pratyashasamal
Icon for Memorable Member rankMemorable Member
3 years ago

Hi 1001 ,
Please try to make the relationship between Masterdata and ZSLED Prior Week Table to bidirectional .
Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C