Groupe By - Max Year - Error

[santu1021]

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		Requried
A	2004		A	2007
A	2005		B	2013
A	2006
A	2007
B	2010
B	2011
B	2012
B	2013

[v-alq-msft · Accepted solution]

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.

[santu1021]

Thank You !!!

[Ashish_Mathur]

Hi,

If the format of the second column in your raw data is a number, then the simple Group By feature of the Query Editor should work flawlessly.  For any more help, share the link from where i can download your PBI file.

[amitchandak]

It is showing "can not parse date value. This seem text,text or text,number values.

Ideally, Max(Year) should work. But In case there is data format issue.

Check the data format of year column, it should be text or Whole number.