Forum Discussion

Helper II

6 years ago

Solved

Groupe By - Max Year - Error

Dear, I'm trying toget max year for the same model and when tried to do groupe by, and to take out max year getting this error message. Any Idea how to fix this error? As-Is Requrie...

Need Help

v-alq-msft
6 years ago
Hi, santu1021

Based on your description, I created data to reproduce your scenario.
Table:

As-ls is text and Year is number. Then you may group by as follows and it appears normal.

Please check the data type for the second column. If possible, please show us your sample data. Do mask sensitive data before uploading. Thanks.

Best Regards
Allan

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