Comparison of two datatables with identical structure, but different selection on one plot

[Freigei5t]

Hi all,

i'm a bit stuck, and i'm pretty sure you can help to find the right direction.

Basically it is TWO tables with timeseries data.

Table1:

Year	Value
2024	5
2025	7
2026	19

Table2:

2024	7
2025	5
2026	21
2027	13
2028	10
2029	5
2030	15
2031	-5

The problem i'm facing is, that if i want to display both of these timeseries in ONE line-plot that the first table will truncate/cut my second tables' dataset as it is having no data from 2027 onwards. 
Depending on the selection, it can also be the other way around (table 1 lasting longer than table2).

I tried to have a helping table with years from 2024 to 2100, but by creating a relationship it again is cutting my helping table.

What would be the best or most elegant solution here?

Thanks for your advice!

[Anonymous · Accepted solution]

Hi @Freigei5t ,

It is possible to create a unified dataset in power query that includes all the years in both tables. This can be accomplished by performing an outer join on both datasets based on the "Year" column.

This way, you will have a complete timeline that covers all the years in both tables. (The handling of missing values depends on your specific business scenario)

Best Regards,
Adamk Kong

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