Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
Let us please assume I have a simple table containing the name of the employee, the month, the salary and the headcount. Headcount can be between 0 and 1 (if an emplyoee is fully employed, it is a 0, if part-time, it is 0.5, if no longer employed, it is 0).
In the pivot, I do see the sum for the salary (no brainer) - however, for the headcount, I'd like to see two things:
1) the average for the selected period
2) the closing balance of the selected period
The selected period can either be a year, half-year, quarter or the month. I have seen the functions CLOSINGBALANCEMONTH, but is there a way to make a CLOSINGBALANCE*ANYTHING*? Same question for averages.
Thanks for any pointers!
Balazs
Solved! Go to Solution.
Hi @Bderi
you can do something like this: https://1drv.ms/u/s!AiiWkkwHZChHjxLqqZGKqGW-VS1o
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Hi @Bderi
you can do something like this: https://1drv.ms/u/s!AiiWkkwHZChHjxLqqZGKqGW-VS1o
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Thanks a lot for the help, LivioLanzo!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |