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
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.

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

        Hi rocky09,

         

        The separate date table can have just one column as a bare minimum.  But you can add columns to bucket dates into Months, Weeks, or Quarters etc if you want.  The main thing is to have a Date/Calendar table that has just 1 row per date (and no more).

         

        You don't need to duplicate your date table with the information from your original table.

         

        Sounds like you are making good progress.