Forum Discussion
Create separate table with Inventamount per month
Hi, I want to build historical data from my import. Will explain: Every day I get the data from an xml file, it's something like ITEM QTY COSTPRICE Item A 2 10 Item B ...
Hi Satch,
I'm not sure I understand why you would export the data from a table visual, and then import it again. I would try using the raw export files, and then build my table from them.
Power Update and Power Query combined shouldn't be neccesary. Power Update is a tool for scheduling refresh, and if you then used Power Query in Excel to update an Excel table in advance, you might have a better setup. Anyway, that's probably to much, compared to what you are after..
/Kim
Thanks Kim,
I will look to this setup later when I have more time and knowledge
For now I use the one mentioned. It's quick an dirty :)