Forum Discussion
Min, max and average by date
If you're just looking to display the data in a table, then there's no need to create a DAX formula. You can use the built-in aggregations, by first:
Add a new column to your table to change the dateTime to date, you can do this with the formula:
Date = INT(Table[DateTime])and changing the type to Date.
next, using a table visual, drag the date (right-click and make sure that "Do not summarize" is selected), then the Value column 3 times. For each of the Value fields, you can then right-click and choose a type of aggregation:
Super UserIf you're just looking to display the data in a table, then there's no need to create a DAX formula. You can use the built-in aggregations, by first:
Add a new column to your table to change the dateTime to date, you can do this with the formula:
Date = INT(Table[DateTime])and changing the type to Date.
next, using a table visual, drag the date (right-click and make sure that "Do not summarize" is selected), then the Value column 3 times. For each of the Value fields, you can then right-click and choose a type of aggregation: