Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello all,
I creating a dashboard from a Form, which contains 2 sections. Each respondent has a unique case_number, the first day he will enter his case_number and answer Section A, then submit his form. the second day he will enter again his case_number, answer Section B and submit his form.
Therefore, in my database I have 2 rows for each case, but only 1 value per column per case (in the row for section A, all the columns of section B are empty, and vice-versa). As below :
And this what I need:
to have only one row for each respondent.
Not that complicated with Max in Advanced Group By in PowerQuery... except I have 244 columns!!! And I need to keep them all...
Is there a way to group by my case_number and then to keep the value (instead of the "null") for all my columns?
Many many thanks for your support!
Ophelie
Hi @dez_im_ope ,
There's no easy way to do this. It's either create a view in your database with the data summarized or use the group by in Power Query (i'm not sure if there is a capacity limit). I'd be inclined to create a view upstream in the database if possible from a performance standpoint.
Hope this helps.
Did I help you today? Please accept my solution and hit the Kudos button.
Hello, thank for your help!
I am not sure to understand what you mean by "create a view upstream" ..?
I guess I will separate my dataset in 2 datasets and then merge them again
Thank you!
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |