Forum Discussion
Power Query to DAX
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]))
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]
icturion , that is new table
amitchandak If i place it in a new table is still get the same error.
Unable to identify the column [work1] in the table
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?
