Finding a sum of a column by date and another column using LookUpValue

[Anonymous]

The table that I want is highlighted and the table I currently have is unhighlighted. 

[JarroVGIT · Accepted solution]

Create a calculated table like this:

Table = SUMMARIZE(Table, 'Table'[Date], 'Table'[Machine], SUM('Table'[duration]))

That will give you the desired result as a calculated table.

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂

[JarroVGIT · Accepted solution]

Create a calculated table like this:

Table = SUMMARIZE(Table, 'Table'[Date], 'Table'[Machine], SUM('Table'[duration]))

That will give you the desired result as a calculated table.

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂

[Anonymous]

When I input that into a new table under the modeling tab I get "Function SUMMARIZE expects a column name as argument number 4". Any idea how to fix this?

[JarroVGIT · Accepted solution]

Sorry that is what you get with posting untested DAX 😛

Table = SUMMARIZE(Table, 'Table'[Date], 'Table'[Machine], "Time", SUM('Table'[duration]))

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂