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.
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!
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 |
---|---|
107 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |