cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
carenel
Frequent Visitor

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 1calculate date 2 Maxcalculate if  date 1oil
01/01/200303/01/2003no  01/01/2003125345
02/01/200303/01/2003no  02/01/20031515
03/01/200303/01/2003yes  03/01/2003155
02/02/200305/02/2003no  02/02/200389582734
03/02/200305/02/2003no   03/02/20037455
04/02/200305/02/2003no  04/02/2003584789
05/02/200305/02/2003yes  05/02/2003543
       
       
       
final table      
calculate ifdate 1oil    
yes03/01/2003155    
yes05/02/2003543    
1 ACCEPTED SOLUTION
amitchandak
Super User
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

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

View solution in original post

3 REPLIES 3
amitchandak
Super User
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

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

View solution in original post

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"

 

carenel_0-1638447323900.png

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
Frequent Visitor

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))

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors