Forum Discussion

ivegotthepower's avatar
ivegotthepower
Regular Visitor
8 years ago

Filter on Dates within different tables

Hi all,   I'm trying to set a filter (with the slicer) on dates/timestamp in different tables, that are not related to each other via this timestamp, but via "Material" and "EAN", as you can see in...
Need Help
Tips and Tricks
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi ivegotthepower,

 

In you screenshot, there're one-to-many relationship between CostList and other tables. It means you can use CostList to filter other tables. Although you can use other tables to filter CostList, it's not recommended because there're some limitations of that.

So to achieve your requirement, you'd better create a datetime table containing a datetime column. Then create one-to-many relationship between your datetime table and CostList table. After that, create a slicer on your datetime column in datetime table.

 

Regards,

Jimmy Tao