Forum Discussion

nelson777's avatar
nelson777
Frequent Visitor
4 years ago

Summarize Bringing Max and Min Dates

Hi, legends,   I'm trying to summarise a table and get the first and last date of the occurrence I'm grouping by. I tried to get there through similar solutions for older posts here, but couldn't ...
v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, nelson777 ;

I tested it and it works well.

1. orginal table.

2.new table.

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples.

 

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.