cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
UmaDevi
New Member

Unpivot similar columns

Hi, good day all.

IDDateAmtTypeDateAmtTypeDateAmtTypeDateAmtType
289 11709-08-22450credit02-07-22450credit28-06-22450credit19-05-22450credit
289 11609-08-224357debit31-07-2212.87debit15-06-222.4debit15-05-2211.23debit
189 19907-08-22190credit16-07-2245debit02-06-2232.99debit26-05-225debit
289 11601-08-2274.8debit02-07-22880.12debit18-06-2237.54debit08-05-222877.12credit
338 11614-08-22100credit02-07-22109.27debit30-06-222.78debit05-05-2298.75debit
338 07412-08-22245debit31-07-2285debit12-06-221007debit25-05-222000credit
189 19914-08-221890.74credit31-07-2232.99debit18-06-2282debit03-05-2244debit
421 22813-08-22150credit01-07-2211.99debit25-06-221.87debit09-05-227.88debit

 

how can i use power query to obtain a summary with headings as below:

IDDateTypeAmt

 

right now i've been writing many sumifs formula which is driving me nuts.

 

Appreciate your help. Thank you

1 ACCEPTED SOLUTION
UmaDevi
New Member

I figured it out.

 

Thank you to 

 

Hoosier BI 

View solution in original post

1 REPLY 1
UmaDevi
New Member

I figured it out.

 

Thank you to 

 

Hoosier BI 

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 25

Ted's Dev Camp - August 25, 2022

Watch Session 25 of Ted's Dev Camp.

Top Kudoed Authors