Forum Discussion

rocky09's avatar
rocky09
Icon for Solution Sage rankSolution Sage
9 years ago

Appending a Column with Yesterdays date

The below is an example of my table. This is basically a stock table (taken for testing purpose). If you look into the last Column LTP i.e today's data.  Generally, When I refresh the table tomorrow,...
Need Help
rocky09's avatar
rocky09
Icon for Solution Sage rankSolution Sage
9 years ago

Phil_Seamark

 

Still puzzling.. Sorry. :)

 

I am getting data directly from Oracle Server. So, every time, I refreshes the table , the previous data will be overwritten. Hence, I cannot have previous data to compare this week.

 

If I create a new table as you mentioned, How it will helpful in comparing. Please adivise. Sorry for not providing clear details before.

Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

AFAIK, there's no such "HISTORIC" feature in Power BI, maybe you can follow this workaround.

For me, I'd prefer to maintain a history table in Oracle database end. If it is not possible, maybe set up an ETL process to extract the data from Oracle to anywhere for archieve purpose so that you can always find the last week, the week before last week etc.