cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ronron New Member
New Member

summarize column with preceeding rows

Hi,

 

i hope someone could help me on my small problem to solve in PowerBI. In sql i would use window functions like "sum(work_diff) over (partition name order by name, date rows unbounded preceding)"

My data table is something like 

 

datenamework_diffwanted result
20190110emp122
20190110emp211
20190111emp2-10
20190112emp233
20190114emp1-11
20190114emp2-12

 

i am searching for the "wanted result" column. In that column should be the summarized value of "work_diff" with all preceeding rows included. I tried already summarize and sumx, but i cant get it working.

Maybe someone could help.

THANK YOU

Ron

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Anonymous
Not applicable

Re: summarize column with preceeding rows

Hi ronron,

See image I've attached and tell us if works for you.

 

summarize.png

1 REPLY 1
Highlighted
Anonymous
Not applicable

Re: summarize column with preceeding rows

Hi ronron,

See image I've attached and tell us if works for you.

 

summarize.png