You know you are using the proper document editor when such a simple job as Collate table invoice does not take more time than it should. Editing files is now an integral part of many working processes in different professional areas, which explains why accessibility and simplicity are essential for editing tools. If you find yourself studying guides or searching for tips about how to Collate table invoice, you might want to find a more easy-to-use solution to save your time on theoretical learning. And this is where DocHub shines. No training is required. Just open the editor, which will guide you through its principal functions and features.
A workflow becomes smoother with DocHub. Take advantage of this tool to complete the documents you need in short time and get your productivity to a higher level!
[Music] welcome to Excel magic trick number 1495 hey were working on the same problem weve been working on the last few videos we got to see how to allocate invoice header amounts to a transaction line-item table and in this video we get to use power query this really should be called power query magic trick hey heres the fundamental problem weve been working on we have won two different transaction or fact tables this table stores the numbers at the invoice level or the header level shipping cost and invoice discount or for the entire invoice but an entire invoice is made up of multiple lines or multiple product recordings where we sold 21 quantity of Sunbelt eighty-eight of Crested Butte and so on and if our goal is to use some criteria or filter or dimension from the line item table on the numbers that exist in the header or invoice tables we have to figure out how to allocate these numbers down to the line level then were allowed to use whatever conditions or criteria filters