Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
date | name | work_diff | wanted result |
20190110 | emp1 | 2 | 2 |
20190110 | emp2 | 1 | 1 |
20190111 | emp2 | -1 | 0 |
20190112 | emp2 | 3 | 3 |
20190114 | emp1 | -1 | 1 |
20190114 | emp2 | -1 | 2 |
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
Solved! Go to Solution.
Hi ronron,
See image I've attached and tell us if works for you.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |