Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
44 | |
20 | |
20 | |
16 | |
15 |
User | Count |
---|---|
46 | |
28 | |
25 | |
18 | |
17 |