Forum Discussion

ronron's avatar
ronron
New Member
7 years ago
Solved

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

  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi ronron,

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

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi ronron,

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