Group By (Table.Group) Expression.Error : unable to apply the .. operator to Null and Null types.

[WelschLucas54]

Hi Everyone,

I want to sum the "DuréeJour" by "ListDate" in order to get one unique date face to a "duréejour" value

So this is my table :

To do this, i use this Group by function :

But after, I got a problem in power query with a Table.Group function :

= Table.Group(#"Autres colonnes supprimées", {"ListDate"}, {{"Nombre", each List.Sum([Duréejour]), type number}})

Expression.Error: Sorry... We were unable to apply the .. operator to Null and Null types.
Details :
Operator=..
Left=
Right=

Could anyone advise me to find another way to do this ?

Thanks in advance.

[WelschLucas54]

Thanks @amitchandak i find the problem with this👍 , i always find me so silly when i see this kind of little thing block me 😅

[amitchandak · Accepted solution]

@WelschLucas54 , You should generate the profile on complete data, there option on the status bar, below the data

and remove the null/blank rows or values