Hi,
I am a brand new Power BI user and I am setting up some data models for my business. Each week I compile three different sales report into one report that shows us our MTD sales in units and volume. This does not take very long to do, but we want to move away from excel reports. So I am now learning how to set this all up in Power BI.
My flat file contains a few vlookups and I have figured out how to use the related function to return the value I am looking for. What I am trying to figure out is how to set this up to update on a weekly baises. I am trying to combine three different reports/files into one, and then have a couple calcualted fields that give me a unique identifer and total sales based on units sold. Like I said, I have the calculated columns figured out...I just dont know the best way to import three different files weekly and get them into one table with the calculated columns? Any help would be appreciated!! Also - any suggestions on courses or training would also be appreciated.
Thank You!
