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!
!! Subscribe to my youtube Channel !!

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!
!! Subscribe to my youtube Channel !!

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
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!