Merging two data tables

[Surya1]

Can someone please help me
I have two tables.Table 1 is having 4 columns n table 2 is having 5 columns.
They both have one same column.I want to merge these two tables on tat same column based on a filter.

How can we do that

[Anonymous]

Did you try the Merge queries feature in Query Editor? Any issue with using it?

[Surya1]

My req is to merge the tables based on a filter which is using selected dates from a date slicer.how can we apply filter in query editor

[v-yuezhe-msft]

@Surya1,

Could you please share sample data of the two  tables and post expected result based on slicer?

Regards,
Lydia

[Surya1]

It got resolved.but am facing another issue.


Posts: 25
Registered: ‎04-05-2018
Static rows in a table
Options
10 hours ago

I have a table
Cola. col b. Col c
Missing. Zzz.xxxx. Today ()
Arrived. Yyy.mmm. Today ()

These columns get updated Daily.Each day wen it is updated I want to copy the rows with missing in cola to a table along with that days date.In the next day next set of missing rows should be appended to the table on top of yesterday s missing data.Yesterdays rows should remain static that is it should not get updated along with new data.Date should also remain the same as yesterday s date.

Can you please help

[v-yuezhe-msft · Accepted solution]

@Surya1，

Incremental data load is not supported in Power BI Desktop, please vote this idea.

Regards,
Lydia