Groupby... Error: We couldnt convert to Number

[Anonymous]

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)

[Anonymous · Accepted solution]

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 Team

If 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

[ronrsnfld]

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.