topic naturalleftouterjoin in Power BI Report Builder in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/naturalleftouterjoin-in-Power-BI-Report-Builder/m-p/2365752#M60557 <P>Hi guys</P><P>I am currently working a lot with the Power Bi Report Builder and getting an overview of working with different datasets:</P><P>&nbsp;</P><P>On one side I have the Entity Questionnaire with the field CompnayNew - here are all IDs of the companies listed which have requested a questionnaire.</P><P>Table Questionnaire :&nbsp;</P><TABLE border="1"><TBODY><TR><TD>CompnayNew</TD><TD>ExampleField&nbsp;</TD></TR><TR><TD>1</TD><TD>TURE</TD></TR><TR><TD>1</TD><TD>FALSE</TD></TR><TR><TD>1</TD><TD>TRUE</TD></TR><TR><TD>2</TD><TD>TRUE</TD></TR><TR><TD>2</TD><TD>FALSE</TD></TR><TR><TD>3</TD><TD>TRUE</TD></TR></TBODY></TABLE><P>Now I want to join the names from the entity Compnay</P><P>Table Compnay:</P><TABLE border="1"><TBODY><TR><TD>[entityId]</TD><TD>[companyName]</TD></TR><TR><TD>1</TD><TD>Test A</TD></TR><TR><TD>2</TD><TD>Test B</TD></TR><TR><TD>3</TD><TD>Test C</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>- but my DAX skills are not enough.</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>(This one is not working...)</P><P>&nbsp;</P><P>Can you help me on this short join. Thank you <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span>&nbsp;</P><P>&nbsp;</P><P>Greetings</P><P>&nbsp;</P> Mon, 28 Feb 2022 22:40:23 GMT DerMoe 2022-02-28T22:40:23Z naturalleftouterjoin in Power BI Report Builder https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/naturalleftouterjoin-in-Power-BI-Report-Builder/m-p/2365752#M60557 <P>Hi guys</P><P>I am currently working a lot with the Power Bi Report Builder and getting an overview of working with different datasets:</P><P>&nbsp;</P><P>On one side I have the Entity Questionnaire with the field CompnayNew - here are all IDs of the companies listed which have requested a questionnaire.</P><P>Table Questionnaire :&nbsp;</P><TABLE border="1"><TBODY><TR><TD>CompnayNew</TD><TD>ExampleField&nbsp;</TD></TR><TR><TD>1</TD><TD>TURE</TD></TR><TR><TD>1</TD><TD>FALSE</TD></TR><TR><TD>1</TD><TD>TRUE</TD></TR><TR><TD>2</TD><TD>TRUE</TD></TR><TR><TD>2</TD><TD>FALSE</TD></TR><TR><TD>3</TD><TD>TRUE</TD></TR></TBODY></TABLE><P>Now I want to join the names from the entity Compnay</P><P>Table Compnay:</P><TABLE border="1"><TBODY><TR><TD>[entityId]</TD><TD>[companyName]</TD></TR><TR><TD>1</TD><TD>Test A</TD></TR><TR><TD>2</TD><TD>Test B</TD></TR><TR><TD>3</TD><TD>Test C</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>- but my DAX skills are not enough.</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>(This one is not working...)</P><P>&nbsp;</P><P>Can you help me on this short join. Thank you <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span>&nbsp;</P><P>&nbsp;</P><P>Greetings</P><P>&nbsp;</P> Mon, 28 Feb 2022 22:40:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/naturalleftouterjoin-in-Power-BI-Report-Builder/m-p/2365752#M60557 DerMoe 2022-02-28T22:40:23Z Re: naturalleftouterjoin in Power BI Report Builder https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/naturalleftouterjoin-in-Power-BI-Report-Builder/m-p/2366505#M60585 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="145205" data-lia-user-login="DerMoe" class="lia-mention lia-mention-user">DerMoe</a> , I think you should keep same name for natural join</P> <P>refer this blog</P> <P><A href="https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/" target="_blank">https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/</A></P> Tue, 01 Mar 2022 06:59:11 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/naturalleftouterjoin-in-Power-BI-Report-Builder/m-p/2366505#M60585 amitchandak 2022-03-01T06:59:11Z