Forum Discussion
Groupby... Error: We couldnt convert to Number
I have 9 columns. 1 is a Date, 8 are Text
I am doing a Groupby. Groupby 1 Column... Date, and it is a Count Rows
i keep getting DataFormatError: We couldnt convert to Number. Details: n/a
i feel like it is a bug, but cant figure how to get around it. any suggestions. (i have tried to Groupby other columns as a test and I get same issue)
Hi Anonymous ,
My guess is that there are records in the aggregated columns that are n/a.
when groupby.
The easiest way to do this is to replace n/a with null before grouping.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
2 Replies
ronrsnfldSuper User
Please post a copy of your data (can be made up data) that illustrates your problem, along with a copy of the code generated in the "Advanced Editor". Please copy/paste as text so we don't have to manually type in data from a screenshot.
Hi Anonymous ,
My guess is that there are records in the aggregated columns that are n/a.
when groupby.
The easiest way to do this is to replace n/a with null before grouping.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum