Forum Discussion

SamDMan004's avatar
SamDMan004
Regular Visitor
6 years ago

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!

No RepliesBe the first to reply