topic Look at 6+ Columns, Return Related Value in DAX Commands and Tips

Look at 6+ Columns, Return Related Value

Anonymous — Fri, 08 Mar 2024 19:46:27 GMT

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!

Re: Look at 6+ Columns, Return Related Value

lbendlin — Sat, 09 Mar 2024 03:04:50 GMT

use the WINDOW function as your filter.

Re: Look at 6+ Columns, Return Related Value

Anonymous — Wed, 10 Apr 2024 02:00:42 GMT

Thank you for your reply lbendlin.

Hi Anonymous
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