Power Query to DAX

[icturion]

I have the following Power Query that works fine in a normal table.

But now i want to use the same formule in a DAX table but thats not possible for so far i know.

So the question is can somebody help me by writing the formule in DAX?

[amitchandak]

@icturion , Try like

Summarize(
union(
selectcolumns(Table, "Date", Table[datein], "Work1", [Work1], "Work2", 0, , "Work3", 0),
selectcolumns(Table, "Date", Table[dateout], "Work1", 0, "Work2", [Work2] , "Work3", 0),
selectcolumns(Table, "Date", Table[datecheck], "Work1", 0, "Work2", 0 , "Work3", [Work3])
), [Date], "Work1", sum([Work1]), "Work2", sum([Work2]), "Work3", sum([Work3]), "Total", sum([Work1])+sum([Work2])+sum([Work3]))

[icturion]

@amitchandak 

Where do i need to place the formula?

Within tabel1? As a Calculated column or measure?

If i place it in a measure i get the following error:

Can't find table with column [work1]

[smpa01]

@icturion Where do i need to place the formula?

[amitchandak]

@icturion , that is new table 

[icturion]

@amitchandak If i place it in a new table is still get the same error.

Unable to identify the column [work1] in the table

[icturion]

@amitchandak 

From this table 'tabel1':

I want to create a new table using DAX that shoud have this as a result:

if i use your formula to create a new table i get the following:

Are I am doing something wrong?

[v-lionel-msft]

Hi @icturion ,

Please provide a sample .pbix file or sample data that can be copied.

Best regards,
Lionel Chen

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

[amitchandak]

@icturion ,Can you share sample data and sample output in table format?

[icturion]

@amitchandak 
Sample data tabel1

Result tabel2: