Forum Discussion
Helper IIGroupe 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 | Requried | |||
| A | 2004 | A | 2007 | |
| A | 2005 | B | 2013 | |
| A | 2006 | |||
| A | 2007 | |||
| B | 2010 | |||
| B | 2011 | |||
| B | 2012 | |||
| B | 2013 |
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.
4 Replies
- amitchandak
Super User
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.
- 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.
v-alq-msftCommunity Support
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.
santu1021Thank You !!!
