Document editing comes as a part of numerous professions and jobs, which is the reason tools for it should be reachable and unambiguous in their use. An advanced online editor can spare you a lot of headaches and save a considerable amount of time if you need to Expand header invoice.
DocHub is a great example of a tool you can grasp very quickly with all the useful features at hand. Start modifying instantly after creating your account. The user-friendly interface of the editor will enable you to find and employ any function in no time. Experience the difference with the DocHub editor as soon as you open it to Expand header invoice.
Being an integral part of workflows, file editing must stay easy. Utilizing DocHub, you can quickly find your way around the editor and make the desired changes to your document without a minute wasted.
[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