Forum Discussion
Solved
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 i...
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))