Forum Discussion

lucioxiii's avatar
lucioxiii
Copper Contributor
Oct 24, 2021
Solved

Power Query - Is it possible to append tables with overlapping data

Hi,   I am new to this community and was hoping to get some guidance around tackling an situation I am facing.   I receive a data in a table format for last 100days every week. I would like to ap...
BI & Data Analysis
excel
power bi
  • SergeiBaklan's avatar
    SergeiBaklan
    Oct 25, 2021

    lucioxiii 

    After you append one to another, in Power Query editor select both columns 

    Home -> Remove Rows -> Remove Duplicates

Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Oct 25, 2021

lucioxiii 

 

but avoid duplicating 07-14 Jan data, is this possible using power query?

 

There is no duplicate data in that period - apart from the dates themself.

 

lucioxiii's avatar
lucioxiii
Copper Contributor
Oct 25, 2021

Detlef_Lewin 

 

Thanks for pointing that out. 

 

I have updated the data in the tables.

 

Table 1

Datedata
1/01/202111
2/01/202186
3/01/202120
4/01/202139
5/01/202121
6/01/202135
7/01/202194
8/01/202123
9/01/202147
10/01/202170
11/01/202197
12/01/202115
13/01/202177
14/01/2021

58

 

Table 2

Datedata
7/01/202194
8/01/202123
9/01/202147
10/01/202170
11/01/202197
12/01/202115
13/01/202177
14/01/202158
15/01/202110
16/01/202143
17/01/202141
18/01/202171
19/01/202196
20/01/202157
21/01/202120
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Oct 25, 2021

    lucioxiii 

    After you append one to another, in Power Query editor select both columns 

    Home -> Remove Rows -> Remove Duplicates

    • lucioxiii's avatar
      lucioxiii
      Copper Contributor
      Oct 26, 2021
      Thank you. That worked 🙂

Resources