Forum Discussion
Need help to get LOOKUPVALUE and PATH functions to a Dataflow
Hello Everyone,
I would like to know if theres a way to get this DAX formula working on PowerQuery formula
This will hurt only a little bit...
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.
2 Replies
- lbendlin
Super User
This will hurt only a little bit...
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.