How to build a report with multiple tables and different dates

[pbilearner1]

Hi all, 

I am trying to build an archive with some datafeeds. These feeds have products from different dates, so I have monthy feeds from the past until YTD. I want to build something where I only have to choose the date to see the product number and the categories to which they belong. 

My problem is that I only can create a many-to-many relation, so that it is impossible to build a filter to choose different dates for showing the data. I guess I need a one-to-many relationship

All my feeds have the same structure, I added also to all a date column and uploaded all feeds separately into Power BI.  It is also possible that e.g. in two or more feeds are existing same products (but also some different products). 

Would be great if I could get any help. Many thanks in advance! 

[Anonymous]

Hi @pbilearner1,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng