Merge with previous step

[DickyMoo]

Hi everyone,

Is it possible to merge two steps of a query together?

I have a list of journal postings, and need to filter it to get a list of journal numbers that relate to cash postings (i.e. those posted to the bank account). I then need to reference this list back to the original full list to be able to highlight which transactions are cash and which are not (i.e. the other side of the transactions).

I've included a small example file, to help my rather poor explanation.

Anyway, to do this I need to apply two separate transformations to my initial data. One to create the list of cash journals, and another that will form the end result. Can I filter down to the list of cash journals, then merge with an earlier step?

Does anyone know how I might do this?

Thanks
Rich

 

[DickyMoo]

I've managed to do it, just had to write the Join formula manually, as below:

= Table.NestedJoin(#"Filtered Rows1",{"Journal Number"},#"Removed Duplicates",{"Journal Number"},"NewColumn",JoinKind.LeftOuter)

 

[DickyMoo]

I kind of glossed over this, but upon reflection this is yet another example of how awesome Power Query is.

What did I ever do without it???