Forum Discussion
Power Query - Need HLP
Hi KIL2022 ,
1.The lookupvalue operation can use the merge function for match filtering. Please refer to
Merge queries overview - Power Query | Microsoft Learn
Solved: How to LOOKUPVALUE in PowerQuery? - Microsoft Fabric Community
2.The countif operation can achieved by group by and custom column. Please refer to
Power Query: COUNTIFS - Microsoft Community Hub
Solved: A simple way for COUNTIF function in power query - Power Platform Community (microsoft.com)
3.To filter the max value group by [visit] and [item], you can use group by feature and custom column.
Group by two fields:
Expand:
Create the custom column:
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi KIL2022 ,
1.The lookupvalue operation can use the merge function for match filtering. Please refer to
Merge queries overview - Power Query | Microsoft Learn
Solved: How to LOOKUPVALUE in PowerQuery? - Microsoft Fabric Community
2.The countif operation can achieved by group by and custom column. Please refer to
Power Query: COUNTIFS - Microsoft Community Hub
Solved: A simple way for COUNTIF function in power query - Power Platform Community (microsoft.com)
3.To filter the max value group by [visit] and [item], you can use group by feature and custom column.
Group by two fields:
Expand:
Create the custom column:
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.