Combine 2 tables from different sources

Hi, HotChilli 

Thanks for your concern about this issue.

Hi, truttafisker 

I am glad to help you.  

According to your description, you want to know will the "new" table's data also being updated, when the data from the SQL server is being updated?

If I understand you correctly, then you can refer to my solution. 

First, you need to confirm that your 2024 data is loaded into Power BI Desktop. If you have successfully loaded it in, you can theoretically find this corresponding Table in the Merge page.

Of course, as you said you found a solution in the community using DAX, which is also possible.

Regarding the question of whether the new table will be refreshed when the data in SQL Server is refreshed, you have to make sure that the data in SQL Server exists on-premises first.

If it is on-premises, you have to install and configure the corresponding on-premises data gateway to ensure that the data can be refreshed normally.

This are some official documentation, hope help you： 

DirectQuery in Power BI - Power BI | Microsoft Learn 

Data refresh in Power BI - Power BI | Microsoft Learn 

Automatic page refresh in Power BI Desktop - Power BI | Microsoft Learn 

Manage a SQL Server data source - Power BI | Microsoft Learn

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,
Fen Ling,

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