Forum Discussion
New table with coincident data.
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 |
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
3 Replies
- amitchandak
Super User
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
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"
How could I combine?
Many thanks
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))
