cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
dmarsh Frequent Visitor
Frequent Visitor

Index/Match Array Equivalent (lookup rows AND columns)

I currently have Table 1 and Table 2 in PowerBi and I want to add the 'YOB Year' column to Table 1. I would use an Index/Match array formula to calculate this column in Excel. Is there a way to do this in PowerBI?
BI Forum - YOB lookup.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
dmarsh Frequent Visitor
Frequent Visitor

Re: Index/Match Array Equivalent (lookup rows AND columns)

I ended up using a combination of Switch and Lookupvalue to populate populate this column. Unfortunately I will have to update this formula as new years are added to the data, but I don't think there is currently an equivalent to an "Indirect" formula in PBI that I can use. 

View solution in original post

1 REPLY 1
dmarsh Frequent Visitor
Frequent Visitor

Re: Index/Match Array Equivalent (lookup rows AND columns)

I ended up using a combination of Switch and Lookupvalue to populate populate this column. Unfortunately I will have to update this formula as new years are added to the data, but I don't think there is currently an equivalent to an "Indirect" formula in PBI that I can use. 

View solution in original post

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)