Forum Discussion

ChrisCam's avatar
ChrisCam
Frequent Visitor
7 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

ChrisCam's avatar
ChrisCam
Frequent Visitor
7 years ago

Hi,

 

The originating data is [PO Number]; [Value]; [Account] and [Overall]

The desired output is the column called "New Account Column"

 

Thanks

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

  • ChrisCam's avatar
    ChrisCam
    Frequent Visitor
    7 years ago

    This is fantastic - thank you ever so much for such a quick response, and making me aware of a feature I did not even know existed :smileyvery-happy: