two tables with the same info : how to get 1 table in PBI

[Grasielecba]

Hello guys,

I have (several actually) tables excel with the same info.

For exemple: the Buyer 1 has his table with data of purchase and number of purchase.

The buyer 2 has his table with same info.

How can I do in Power BI one graphic that relates the number of purchases per date by filtering by the buyer?

Thanks a lot,

Best Regards,

Grasiele.

[Grasielecba]

Hello guys,

I have (several actually) tables of excel that I have the same info. Like name of the buyers and purchase date.

And I need to do a grafic with (number of purchase x date ) in a way that I can filter by buyers names.

Could someone help me? 

Thank you very much!

[MFelix · Accepted solution]

Hi @Grasielecba,

Using Power Query you should append all the table into one and then using a dimension table for dates you can filter it out.

Regards,

MFelix