Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Relative Reference

I am trying to write a formula for PowerQuery that looks at a cell value and if it equals a specified value retuns the value of a cell that is in the next row and over one column. I want this value t...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Since i could not get the ref to work i ended up doing the following

     

    Adding two Index columns one starting with 0 the other with 1

     

    Doing a merge table with itself and refrencing the two index columns. this shifted the time values to the same line as the Action and then it became a simple if statment without the ref. 

     

    Thanks all for the ideas& help on this one! 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

So far I have gotten to 

 

= Table.AddColumn(#"Added Index1", "NotReady", each if [Action] = "Release (Not Ready) " then {[Index1]+1}[Time] else null)

 

This is not working and I am not sure why. Anyone have any pointers? 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

I keep getting the following error with the above formula:

 

Expression.Error: We cannot apply field access to the type List.
Details:
Value=List
Key=Time

 

Any ideas on how to resolve this?