Appending a Column with Yesterdays date

I have the same situation, but thankfully my report data volume is low where i just run the latest report every monday @6am and place the report (excel format) into a folder.  Within the report I included the field attribute "Report Ran Date" so it automatically populates a column with the date it was ran.  I then do the following:

1. Create a new PowerBI Query that is directed at the FOLDER that contains all the excel files

2. Make basic modification in PowerQuery

3. Create the new report using two main calculations:  

A: CUrrent Week data: CALCULATE(SUMMEASURE),LASTDATE(LOCATION OF REPORT DATE COLUMN))  The CALCULATE and LASTDATE formulas are required to use for every measure you make in order to extract out the current data from all the files. (LASTDATE is what finds the most current data)

B: Previous Week data calcs: =CALCULATE([SUMMEASURE],DATEADD(LASTDATE(LOCATION OF REPORT DATE COLUMN),-7,DAY))  WHat this does is it calculates the measure you create for the current values and it now calculates the previous week by looking at that report date column.  The LASTDATE plus -7, DAY gets you the previous week data

C: Now just make another measure called change which is CURRENT-PREVIOUS weeks measures.

Hope this helps you get started.

Hi rocky09,

Do you have date columns in the tables you are collecting from Oracle?  

Eg, do you collect Sales data where there is a column that carries the datetime of the transaction?

If any of your tables have a Datetime column you can create measures in Power BI to show this over time as well as make comparisons.

If you aren't getting date info in your data then it makes it a little hard.