Max and Min date for each reserv ID

[Anonymous]

Hello all

If possible, i wanna know for each row, in edit queries, the max and the min of a specific date field for each reserv ID. 1 column each.

I did it in the table view and also by grouping (duplicating the previous qry) but i believe it's better, for future calculations that i should have these new 2 columns on the query, as well as faster.

Can you help me please?

[v-yuta-msft · Accepted solution]

Hi pedromooji,

You can use "Group by" in power query to achieve aggregated value by category. Please refer to: https://support.office.com/en-us/article/group-rows-in-a-table-power-query-e1b9e916-6fcc-40bf-a6e8-e...

Regards,

Jimmy Tao

[Anonymous]

That's it. Thank you very much