Forum Discussion
Power Query - Data manipulation
I have data setup like the below table. Every time something is received the system creates a dash that is one higher than the prior one which shows everything that is yet to be received. I'm trying ...
A seemly rookie question but, in fact, fairly tricky.
Now, here is the question. How do you aggregate this for all POs? Because I do want to be able to drill to that level, but most often I'd be looking at the vendor level or just overall backorder amount and tracking that. Again this is why my initial thought was Power Query.