Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello!
I am learning to use Power BI and ran into problem with this data. My data is similar to the yellow table - different numbers of columns with same name - and I want to transform it to blue table - to calculate average for the sampls with same name for each timepoint - as easily as possible.
Solved! Go to Solution.
Hi, @nufffins
You need to split the original table into the following two tables and append them again.
Best Regards,
Community Support Team _ Eason
Hi, @nufffins
You need to split the original table into the following two tables and append them again.
Best Regards,
Community Support Team _ Eason
Thanks, it works!
User | Count |
---|---|
93 | |
86 | |
78 | |
72 | |
66 |
User | Count |
---|---|
115 | |
106 | |
85 | |
65 | |
64 |