Creation a investment valuation table from two indirect tables Programming Databases by ShortYute … I’m using now** I’ve uploaded my info into PowerBI however, I can’t seem to create a table to… excel / screenshot below, how would I create that table in PowerBI? 2. What is the best way to store/access that… information? E.g. Access/Excell/PowerBi/SQL etc. (free solutions please) Thank you so much for… Re: Creation a investment valuation table from two indirect tables Programming Databases by ShortYute Good afternoon, I figured it out, the way to go about doing this is to use PowerQuery in excel (I'm using Excel 2016). First you would create the tables in the workbook then add each of them to PowerQuery using the Data/From Query command. You would then create relationships between the data then use the merge query to join the tables that you …