Forum Discussion
rocky09
Solution Sage
Solution SageAppending 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,...
rocky09Solution Sage
Solution SageI was asked by my management to show comparision between Last week and present week. But, My probelm is, I am fetching data directly from Oracle Server. So, When I refresh the data, all the data will become latest.
Can anyone suggest me some good way to achieve this. I am not sure whether there is a historical table existing in Oracle server or not.
Phil_Seamark
Microsoft Employee
Microsoft EmployeeHi 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.