Measure/DAX-table from 2 tables

[RhoFox]

Hi all
I need Help for a Measure (Or Maybe its better with a whole table)

i have 2 tables:
table1 = importet table

ID	Name	Comment	Date	Status
1	name1	test1	01.01.2021	finish
2	name2		09.02.2021	finish
3	name3		15.05.2021	delay
4	name4	test1	01.06.2021	at work
5	name5	test1	16.06.2021

table2 = directquery table

ID	Name	Comment	Date	Status	Create by	Timestamp
1	name1	test2			name1	01.06.2021 17:36
3	name3			finish	name2	01.06.2021 17:45
5	name5	test2	20.06.2021		name1	01.06.2021 17:50

in this table i have only the changes of some data

what i need in my visual:

ID	Name	Comment	Date	Status	Create by	Timestamp
1	name1	test2	01.01.2021	finish	name1	01.06.2021 17:36
2	name2		09.02.2021	finish
3	name3		15.05.2021	finish	name2	01.06.2021 17:45
4	name4	test1	01.06.2021	at work
5	name5	test2	20.06.2021		name3	01.06.2021 17:50

so the goal is to have some combination of those 2 tables, i need all the datas of the table1, but when in table2 is some update, i need the updatet datas inside.

i am not sure what is easyer, to make for every column a own measure where is something like

if table1[column1]=blank then table2[column1] else table1[column1]
so i need helf for this measure 🙂

or if its mabe better to create a own DAX-Table?
Thank you a lot

[amitchandak]

@RhoFox , One way is create an imported table in power query using append.

Another is to have common dimensions name, status and date and use that to analyze data together

[RhoFox]

hi @amitchandak 
Thank you for your response 🙂
the problem is that i need the datas from the table2 live, thats why I can't import them.
I don't know what you mean with the second suggestion, can you explain it to me?