Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
BI-Leo
Frequent Visitor

Vlookup

‎08-31-2022 08:17 PM

Hi Everyone, I tried to transfer fomula Vlookup in Excel to PowerBI Desktop, but I am unable to do so. My aim is to extract column B in 'Group' sheet, here's my formula in Excel '=VLOOKUP(A:A,Group!A:B,2,TRUE)'

2022-09-01_11-04-41.png               2022-09-01_11-05-14.png

I know LOOKUPVALUE there in PowerBI, but it cannot deal with such scenario, so currently I am writing below DAX in PowerBI, but it isn't flexible enough, is there any other approches to solve such scenario? 

2022-09-01_11-12-18.png

Hopefully someone could help, Thank you!

 

 

Labels:
Message 1 of 4
552 Views
0
1 ACCEPTED SOLUTION
Anonymous
Not applicable

‎09-02-2022 12:58 AM

Hi @BI-Leo,

It sounds like a segmentation related requirement, you can take a look at the following blog to know how to use DAX expression to achieve these:

Static segmentation – DAX Patterns

Regards,

Xiaoxin Sheng

View solution in original post

Message 3 of 4
505 Views
0
3 REPLIES 3
Anonymous
Not applicable

‎09-02-2022 12:58 AM

Hi @BI-Leo,

It sounds like a segmentation related requirement, you can take a look at the following blog to know how to use DAX expression to achieve these:

Static segmentation – DAX Patterns

Regards,

Xiaoxin Sheng

Message 3 of 4
506 Views
0
BI-Leo
Frequent Visitor
In response to Anonymous

‎09-06-2022 01:48 AM

Thanks a lot bro, what a brilliant idea! I created a  column in Group to find its next row, and then match Group and Data, it works!

Message 4 of 4
487 Views
0
BI-Leo
Frequent Visitor

‎08-31-2022 08:19 PM
'Data'[No. of Lives] in DAX can treat as column A in Data sheet
Message 2 of 4
550 Views
0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All