Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Hi,
I want to take this table:
And summarize it like below (by account & line number).
Any tips??
Solved! Go to Solution.
Hello @PowerBI123456 ,
Have I answered your question? Please mark my answer as a solution. Thanks a lot.
If not, load some insensitive data samples and expected output.
Best regards
Eyelyn Qin
Hello @PowerBI123456 ,
Have I answered your question? Please mark my answer as a solution. Thanks a lot.
If not, load some insensitive data samples and expected output.
Best regards
Eyelyn Qin
@PowerBI123456 , Try to pivot this data.
https://radacad.com/pivot-and-unpivot-with-power-bi
Video: https://www.youtube.com/watch?v=oKByyI09Bno
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.