Group multiple values on the same date in Query Editor

[Anonymous]

I have copied my main data sheet and removed all columns except for date calculated by start of week and the mulitple price values, so I have (chart below), is there a way to get the average price per day via DAX / Query Editor?

[dax]

Hi @Anonymous ,

You could refer to @az38 's suggestions to use average in visual or you also could try to use below M code 

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMrDUNzDWNzIwMlDSUTLRMzVWitXBELW0IF7U1BBT1FTPCJtSA6gBRiii5saYoqYwtUYm+kAJqKgZ1FgUQYi7YgE=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [#"Date " = _t, value = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Date ", type text}, {"value", type number}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"Date "}, {{"avg", each List.Average([value]), type number}, {"all", each _, type table [#"Date "=text, value=number]}}),
    #"Expanded all" = Table.ExpandTableColumn(#"Grouped Rows", "all", {"value"}, {"value"})
in
    #"Expanded all"

Best Regards,
Zoe Zhi

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

[az38 · Accepted solution]

@Anonymous 

the easiest way is to add both columns to visual and set aggregation as "Average" for Price field in visual settings

It doesn't demand any programming