none
Power Query loop table RRS feed

  • Question

  • First of all I'm new to power query, so I'm taking the first steps. But I need to try to deliver sometime at work so I can gain some breathing time to learn.

    I have the following table (example):

    Orig_Item       Alt_Item    
    5.7             5.10
    79.19           79.60
    79.60           79.86
    10.10           
    

    And I need to create a columm that will loop the table and display the final Alt_Item. So the result would be the following:

    Orig_Item       Alt_Item        Final_Item  
    5.7             5.10            5.10    
    79.19           79.60           79.86   
    79.60           79.86           79.86   
    10.10           
    

    Many thanks

    Wednesday, August 23, 2017 2:53 PM

Answers

All replies