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
User | Count |
---|---|
94 | |
86 | |
78 | |
70 | |
63 |
User | Count |
---|---|
114 | |
99 | |
97 | |
65 | |
59 |