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,

 

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's avatar
ivegotthepower
Regular Visitor
8 years ago

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