Getting full control over your documents at any moment is crucial to relieve your everyday duties and increase your efficiency. Achieve any goal with DocHub features for document management and convenient PDF file editing. Gain access, modify and save and incorporate your workflows along with other secure cloud storage.
DocHub offers you lossless editing, the opportunity to use any formatting, and safely eSign documents without having searching for a third-party eSignature software. Make the most of your file managing solutions in one place. Try out all DocHub capabilities today with the free of charge profile.
now that we have that location table we want to create a new and improved sales fact table so lets begin by clicking transform data to bring us back to the power query editor and were going to do this by using merge queries a brilliant feature of power query and on the sales prep table up in the Home tab merge queries is on the end and I want to click the drop down arrow so that I can specify to merge queries as a new query I dont want to affect the current sales prep query because my location query is referencing it from the previous lesson I want a new query which will be our sales fact query now in the merge window I have the sales prep table selected because I began the merge query from it but then I have this drop-down list where I can specify the location table so what I want to do here is bring in the location ID from the location query or table so that in the sales table I can remove the location column and also the country column and the location ID will be used to referen