Forum Discussion
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...
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!
I have been using excel to do this function for a while and i can just have a formula that is "=if(c7='Release (Not Ready)', D8,0) and it works great. I am trying to make the change to Power BI because it offers alot of functions that Excel doesnt.. any help would be met with great enthusiasm.