Forum Discussion
How to execute calculation based on specific row value from different data source
Hi Community, I am stucking here in this topic and went through quite some web support including youtube video. Must appreciate if someone could help. Excel file 1. Sales record from (past ye...
Hi Watson ,
You could try to merge tables in Power Query.
Merge queries (Power Query) - Microsoft Support
Merge queries overview - Power Query | Microsoft Learn
Then you could add a conditional column to get the judgment statement you want.
Add a conditional column (Power Query) - Microsoft Support
Add a conditional column - Power Query | Microsoft Learn
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.