New table with coincident data.

[carenel]

Hello community,

I have calculated new columns in two different tables.

I need to join both tables in one and just show the rows where the column calculate if is "yes"

How can I do it? because in porwerquery do not show new calculated columns.

Many thanks

table1					table2
date 1	calculate date 2 Max	calculate if			date 1	oil
01/01/2003	03/01/2003	no			01/01/2003	125345
02/01/2003	03/01/2003	no			02/01/2003	1515
03/01/2003	03/01/2003	yes			03/01/2003	155
02/02/2003	05/02/2003	no			02/02/2003	89582734
03/02/2003	05/02/2003	no			03/02/2003	7455
04/02/2003	05/02/2003	no			04/02/2003	584789
05/02/2003	05/02/2003	yes			05/02/2003	543
final table
calculate if	date 1	oil
yes	03/01/2003	155
yes	05/02/2003	543

[amitchandak · Accepted solution]

@carenel , In case you want to merge in power query , you need to first convert this calculated column into power  query

Seem like category max - https://www.youtube.com/watch?v=8KaMj2DFpWg

Then you have merge the queries https://radacad.com/append-vs-merge-in-power-bi-and-power-query

[carenel]

Thank you amitchandak for the links and the reply.

I think I have a problem with concepts and I used to think like MS Access.

I have created two calculated columns "ult mes" and "sino"

I have been looking for these calculated columns but query does not show them.

How can I link the data in table A with Table B but the filter "column sino = 1"

https://justbeamit.com/dmeq6

How could I combine?

Many thanks

[carenel]

Finally, create a new table with the filters and then join the other  tables with RELATED

Tabla =

filter(cal_mes,

cal_mes[ult_mes] = 1 &&

cal_mes[date]> date(2003,9,1))