Add column to an existing table imported from Excel

[lhaz]

Hi,

I have a table (Table1) like this which is imported from Excel 

And I want to add a column starting at a certain date and then increasing with one day, like this:

Is this possible in any way? I tried using the CALENDAR function but that creates a whole new table instead of adding a column to an existing table. I actually already have the correct date column in a date table. So it would also be fine if I could add this column to Table 1 mentioned above. 

Thanks!

Laura 

[v-juanli-msft · Accepted solution]

Hi @lhaz

What relationship is between the Table1 and date table?

add a column starting at a certain date and then increasing with one day

You need to define which certain date to add for the first row.

If they have proper relationship, you can create a calculated column in Table1 with the function Related, like

column1=RELATED (Date Table [date])

Best Regards

Maggie