Combining 2 sheets of data into 1 table

[Anonymous · Accepted solution]

Hi, @RichOB 

Use the Merge Queries feature in Power Query Editor to combine your Balance and Budget data based on a common key that uniquely identifies each scheme.

Here's a step-by-step guide on how to merge queries:

Tutorial: Shape and combine data in Power BI Desktop - Power BI | Microsoft Learn

After merging, carefully review the merged table to ensure that each scheme's Budget figure is correctly aligned with its Balance. You may need to expand the merged columns to include the Budget figures explicitly.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data)

Best Regards

Yongkang Hua

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