Forum Discussion
Measure/DAX-table from 2 tables
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
2 Replies
- amitchandak
Super User
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
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?
