Merging two datasets into one Data Table

Hi, Anonymous 

Based on your description, i created data to reproduce your scenario. The pbix file is attached in the end.

Actual:

Budget:

You may create a calculated table with the following dax.

Table = 
ADDCOLUMNS(
    Budget,
    "Hours Actually Worked",
    CALCULATE(
        SUM(Actual[Actual Value]),
        FILTER(
            Actual,
            [Name]=EARLIER(Budget[Name])&&
            [Time Sheets]="on-site time"
        )
    )
)

Result:

Best Regards

Allan

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