Group By: Not Working

[New_be]

Hi expert! I have one problem that i think people from this community can help me with 😊

Problem:

I want to group a value column based on certain columns. But when I use function grouped by, it seems doesn't worked. Below are the examples:

Based on this image, I want to group columns ARTICLE, PRD_ORDERID, and PRODUCTION_DATE to get sum of SF (square feet). As we can see in the red square I have same ARTICLE, same PRD_ORDERID & CUSTOMER but different PALLET_NUMBER. So i want to ignore PALLET_NUMBER because I just wanted to know how many SF have been produced on certain date, for a certain order id & article number.

Result:

Below is the result that i got from grouped by function. It still shows multiple rows for the same PRD_ORDERID & PRODUCTION_DATE.

Desired output:

My desired output is for PRD_ORDER = 4477549 and PRODUCTION_DATE = 27/6/2020, I just want one row that shows sum of SQFT for the particular order & date.

PRD_ORDERID	PRODUCTION_DATE	SQFT
4477549	27/6/2020	Sum of sqft
4477549	29/6/2020	343.71

Any idea why this is happening? Thanks in advance!

[amitchandak · Accepted solution]

@New_be , I doubt your date has timestamp

Create a date from production date in power query and try with that date

DateTime.Date([production_date])

[New_be]

Thanks @amitchandak ! 😃 Its work like you said. But i don't know why it is not working for me before as i already converted the datatype.