Forum Discussion
Data disappears after GROUP BY
I have a dataset with a number of columns of different data types. To calculate a new variable, I use a Group By and include an "all rows" column before expanding the original table. There are no problems with the new variable and all original variables except
(1) one date column becomes completely blank, and
(2) 10 rows of data disappear.
Has anyone come across a similar problem before or know what could be causing this?
3 Replies
v-yalanwu-msftCommunity Support
Hi, Anonymous ;
I tested similar simple file ,and it works .
2.then when we expand columns.
The final show:
So you could check when you expand columns how to operate?
and if not right, you could try reduce Row data in order to make the data smaller, see if it is caused by the data being too large.
if not ,can you share your file whitout sensitive data?
How to upload PBI in Community
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi v-yalanwu-msft,
Thank you for your reply. Turned out there was a typoin the field name (one lowercase letter instead of an uppercase one) in the Group By step . I got no error message but the column values turned to null. Adjusted the name and it works now 👍
- v-yalanwu-msft
Hi, Anonymous ;
Is your problem solved? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.