Summarize Table with Criteria

[PowerBI123456]

Hi,

I want to take this table:

And summarize it like below (by account & line number). 

Any tips??

[Anonymous · Accepted 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

[amitchandak]

@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.