Look at 6+ Columns, Return Related Value

[MSnake]

Hi! I am trying to figure out a formula that looks at 6+ values in a row, references my related table and returns the matching value. The LOOKUPVALUE + RELATED function combined has gotten me results for a particular value, however I need to analyze multiple columns. Any help would be greatly appreciated!

Thank you!

M

[v-jialongy-msft]

Thank you for your reply @lbendlin.

Hi @MSnake 
Is your problem solved now? If not, can you provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.

Best Regards,

Jayleny

[lbendlin]

use the WINDOW function as your filter.