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

I 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's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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.

 

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

    AnonymousThank you for your suggestion.

     

    Phil_SeamarkYes, the table has transaction date. Can you guide me, how can I use measures.?

    • Phil_Seamark's avatar
      Phil_Seamark
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      When you bring that data in, convert the column to be using just the DATE datatype.  Then connect that column to a separate Date Table where you will have just 1 row per date.  This will be the table that drives your "Time Intelligence".  Essectially this will unlock the functions like SAMEPERIODLASTYEAR, PARALLELPERIOD etc to build the measures you will likely need.

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

        Phil_Seamark

         

        Then connect that column to a separate Date Table where you will have just 1 row per date.

         

        Thank you. I am not getting it. Do I need to duplicate the Date Table with all the information from the Original Table. Sorry for my poor understanding.