Need help to get LOOKUPVALUE and PATH functions to a Dataflow

This will hurt only a little bit...

Replicating PATH function of DAX in Power Query / M – Power BI & Excel are better together (excelnaccess.com)

Hi AlanSphinx ,

Thanks to lbendlin  for the method, I would like to add something about lookupvalue.

In dataflow, you can use a merge query to lookup columns. The merge query operation joins two existing tables together based on matching values in one or more columns. You can choose to use different types of joins depending on the desired output.

For more detailed information you can refer to the link:

Merge queries overview - Power Query | Microsoft Learn

Solved: How to LOOKUPVALUE in PowerQuery? - Microsoft Fabric Community

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.