https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/VlookUp-and-CountIF-DAX/m-p/846261#M6552 <P>Hi all,&nbsp;</P><P>&nbsp;<BR />New to Power BI and facing some difficulties trying to replicate a vlookup result in Excel to Power BI.</P><P>&nbsp;</P><P><U>Column A&nbsp;</U> &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<U>Column B</U>&nbsp; &nbsp;&nbsp;<SPAN>&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN><U>&nbsp;Column C&nbsp;</U><SPAN> &nbsp; &nbsp; </SPAN><U>Column D</U></P><P>Description1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Description1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Description1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2</P><P>&nbsp;</P><P>Basically&nbsp; Column C /Formula=COUNTIF(B:B,B5)&nbsp; is doing a count if of Description1 in Column B which I am ble to replicate in PowerBI</P><P>However in Column D/ Formula = VLOOKUP(A4,B:C,2,FALSE) , I am doing a simple VLOOKUP of Decription1 from column A in column B and extracting out Column C values.</P><P>I am unable to replicate this in PowerBI.</P><P>&nbsp;</P><P>Any support or advice would be mch appreciated, Thank you!</P> Thu, 14 Nov 2019 13:36:51 GMT SamDMan004 2019-11-14T13:36:51Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/VlookUp-and-CountIF-DAX/m-p/846261#M6552 <P>Hi all,&nbsp;</P><P>&nbsp;<BR />New to Power BI and facing some difficulties trying to replicate a vlookup result in Excel to Power BI.</P><P>&nbsp;</P><P><U>Column A&nbsp;</U> &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<U>Column B</U>&nbsp; &nbsp;&nbsp;<SPAN>&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</SPAN><U>&nbsp;Column C&nbsp;</U><SPAN> &nbsp; &nbsp; </SPAN><U>Column D</U></P><P>Description1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Description1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Description1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2</P><P>&nbsp;</P><P>Basically&nbsp; Column C /Formula=COUNTIF(B:B,B5)&nbsp; is doing a count if of Description1 in Column B which I am ble to replicate in PowerBI</P><P>However in Column D/ Formula = VLOOKUP(A4,B:C,2,FALSE) , I am doing a simple VLOOKUP of Decription1 from column A in column B and extracting out Column C values.</P><P>I am unable to replicate this in PowerBI.</P><P>&nbsp;</P><P>Any support or advice would be mch appreciated, Thank you!</P> Thu, 14 Nov 2019 13:36:51 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/VlookUp-and-CountIF-DAX/m-p/846261#M6552 SamDMan004 2019-11-14T13:36:51Z