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 the image below. 

 

I need to filter the data based on the timestamp as well as on the productnumber-relationship. 

 

Is there any way to realize that? 

Thanks so much in advance for any help!

 

Jonas

Need Help
Tips and Tricks

4 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community 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

    • ivegotthepower's avatar
      ivegotthepower
      Regular Visitor
      8 years ago

      HI v-yuta-msft,

       

      thanks for your response!

      Can you help me with the one-to-many Relationship between "CostList" and the new "datetime"-table?

      Which column should I use for this Relationship? The "CostList" doesn't contain any datetime-information.

       

      Thanks and Best Regards

      Jonas

      • v-yuta-msft's avatar
        v-yuta-msft
        Community Support
        8 years ago

        Hi ivegotthepower,

         

        What does productname relationship mean and could you please provide more details about which datetime column do you want to filter?

         

        Regards,

        Jimmy Tao