Forum Discussion
Solved
Get next non blank value in column
Hi everyone, I hope you can help. I have a report that summarises POs for each account, and then before the next account it shows the account number and overall value. Ideally I need to show th...
Hi ChrisCam ,
You can achieve this in powerquery with couple of steps, See below:
1st 4 columns is originated data last columns is desired out put data
To achieve this Go to Edit Queries -->> Transform tab --->> Click on Fill (See below img)
Thanks & Regards,
B V S S
Apologies the table I attached was not very clear - I need to add a new column which should reflect the below:
PO Number Value Account New Account Column Overall O000100/01252 9.2 100.2011 0 100.2011 100.2011 9.2 O000100/01228 91.71 100.2104 0 100.2104 100.2104 91.71 O000950/02810 16.7 100.2211 0 100.2211 100.2211 16.7 O000100/01303 469 100.2242 0 100.2242 100.2242 469 O000100/01304 70.38 100.2334 0 100.2334 100.2334 70.38 O000100/01227 95 100.241 O000100/01227 95 100.241 O000100/01227 95 100.241 O000100/01298 290 100.241 0 100.241 100.241 575
