Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
I am a n00b here, so bear with me. I have a data set where I am trying to find multiple median values, and then want to find the weighted average of those medians.
Here is a sample data set:
I am trying to find a median of Total for each of the Group A and Group B combos: AC, BC, AD, BD. My Data set has a large number of combos, so I am looking for something dynamic.
Part 2 would be to then take the medians I just found, and perform a weighted average.
Is there a way to do this?
Solved! Go to Solution.
@DEFresh3451 Here is a way you can do this.
Create a new column which combines Group A and Group B
Then create a table that gets the median value per combo group:
Not sure what you mean by weighted average of medians- can you please explain further or post an example of the desired result?
@DEFresh3451 Here is a way you can do this.
Create a new column which combines Group A and Group B
Then create a table that gets the median value per combo group:
Not sure what you mean by weighted average of medians- can you please explain further or post an example of the desired result?
Thank you!!!
User | Count |
---|---|
53 | |
28 | |
19 | |
18 | |
14 |
User | Count |
---|---|
92 | |
86 | |
39 | |
23 | |
22 |