Forum Discussion
VlookUp and CountIF DAX
Hi all,
New to Power BI and facing some difficulties trying to replicate a vlookup result in Excel to Power BI.
Column A Column B Column C Column D
Description1 2
Description1 2
Description1 2
Basically Column C /Formula=COUNTIF(B:B,B5) is doing a count if of Description1 in Column B which I am ble to replicate in PowerBI
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.
I am unable to replicate this in PowerBI.
Any support or advice would be mch appreciated, Thank you!