possible to create a table to store dates as a log and adds new dates from dataas they come

[Earl40]

Hi Im not sure if this is possible but I have a data set that will be downloaded from a system weekly. It has a column for "date downloaded" which shows the date the data was exported from the system to excel. I was trying to figure out a way to create a table that will only store the date shown in the download and then as the main  data is refreshed in PowerBi take the new date and add it to the seperate date table as a new row without losing the previous dates.

Illustrative example: I downloaded the data to use in my PowerBi dashboard on 3/1/24 and the date downloaded column shows 3/1/24. The new date table grabs that date 3/1/24 and adds it. The next week 3/8/24  i take a new download, refresh PowerBi. The new table will take the date 3/8/24 and add it as a new row undeneath the 3/1/24 date. 

Thank you in advance

[Anonymous · Accepted solution]

Hi @Earl40 ,

Regarding your question, I think it can be done by using Power query. Open power query in power bi desktop and create a blank query.

I am assuming that you are using excel to store the data using the following sample code:

let        
Source = Excel.Workbook(File.Contents("C:\Users\YourUsername\Desktop\YourFile.xlsx"), null, true),     
Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],      
SelectColumns = Table.SelectColumns(Sheet1_Sheet, {"Columnname"}) 
in    
 SelectColumns

Replace "Sheet1" with the table where you store the download date columns, replace "Columnname" with the download date column. The above code returns a new table containing only the download date column, and each refresh refreshes the data in the download date column.