Forum Discussion
Count how many checkboxes checked per case
I have 3 checkboxes per case Response missed Restore missed Resolve missed I want to know how many may be checked per case. 0, 1, 2 or all 3 may be checked on any case
Hi gilmore_staci ,
You want to implement group counting in Power Query, right?
If so, I created a sample for trying to illustrate this solution.
Sample data:
Right-click "Case" and select "Group By...".
Set up as follows.
Click OK.
Expand the column you want.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.