Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I would like to create an additional column called "Index" that shows the number of surveys per employee. For example, in this screenshot, it looks like employee S-249 has four corresponding Surveys in the "Survey #" Column. What code would I write for an additional column that would show the number of surveys per employee?
Thanks, Kendall
Solved! Go to Solution.
Hi,
you have to group only for Emplyee and then the count is going to be on surveys
great, that worked out. thanks, kendall
Thanks serpiva. Forgive me as this is a basic question: where would I find the Group By function in the query editor? Thanks.
Hi,
here it is
Hi,
you have to Group By; something like this
then you expand your nested table and in the column Count you have your result (if you need to count for a period of time you have to add another Grouping
If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!
Hi Serpiva, so I am doing this, but when I put this out my Index column keeps coming out as "1". Why is it unable to count the number of surveys per employee? Thanks, Kendall
Hi,
you have to group only for Emplyee and then the count is going to be on surveys
When I do that, it comes out with only two columns:
Is there anyway I can do this by adding a custom column to this existing Query using the Table.AddColumn function?