Forum Discussion
Merging two columns from to tables based on date
Hi, I have to different tables like the following: Table 1 Date Revenue Product Name 13.01.2020 50€ Alpha 16.01.2020 30€ Beta Table 2 Date Revenue Productname ...
Hi iiomarioii ,
If the structure of both of your tables is exactly same, you can use Append queries to merge these 2 tables into ONE SINGLE TABLE in Query editor in Power BI.
You can refer following article to achieve this:
https://yodalearning.com/tutorials/top-3-steps-to-append-queries-using-power-query/
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
This is the solution. I have tried it before but it's very important that the Columns have the same name!!