Filter on Dates within different tables

[ivegotthepower]

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

[v-yuta-msft]

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]

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]

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

[ivegotthepower]

Hi @v-yuta-msft,

thanks again.

My purpose is to create a report page, that combines data out of the following tables with the also following relationship-relevant-columns: (The "..." represents the key figures to display in the report)

1. Artikel (S530)
   1. European Article Number (EAN)
   2. CalendarDay
   3. ...
2. Lokale DB-Rechnung
   
   1. European Article Number (EAN)
   2. CalendarDay
   3. ...
3. Cost List
   1. European Articel Number (EAN)
   2. Amazon Standard Identification Number (ASIN)
   3. ...
4. RVDATAPOOL
   1. Amazon Standard Identification Number (ASIN)
   2. CalendarDay
   3. ...

Within the report-page I would like to be able to filter the time with the slicer, for example to compare the data out of the RVDATAPOOL and the Artikel-table within the last week. 

Actually I'm only able to filter either the CalendarDay within the RVDATAPOOL-table or within one of the other tables but not on all calendarday at the same time, with a single filter. 

I Hope this clarifies my problem. 

Thank you and Best Regards,

Jonas