Forum Discussion
Post PartisanSummarize Table with Criteria
Hi,
I want to take this table:
And summarize it like below (by account & line number).
Any tips??
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
2 Replies
- amitchandak
Super User
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. 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
