Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to 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 , 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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |