Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
Thanks @amitchandak i find the problem with this👍 , i always find me so silly when i see this kind of little thing block me 😅
@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