add column date self-incremental

[apc_123]

Hello good morning

I'm using a provider's API (reviewpro) to download the survey from a /(from) date to a date(to)

so far there's no problem, but that download doesn't come the date.

the first record is 01/01/2019

02/01/2019 and so on.

I would be interested in creating a date column that from one day (01/01/19) was self-creating.

this way I could link that table to the calendar.

Thanks a lot!

[amitchandak]

@apc_123 , Not very clear

you can create a calendar like

Calendar(Min(Table[Date]), Max(Table[Date]))

If you are looking for allocation or distribution, check the file attached

[apc_123]

hello good morning

I'll try to explain myself better...

Through an API, powerbi downloads logs from 01/01/2019 to today, in this format:

0.9

0.8

0.85

etc

but of course, I don't have a date column. I'm interested in adding a column to each record that increases the start date and looks like this:

0.9 01/01/19

0.8 02/01/19

0.85 03/01/19

this way I can join it to the calendar table

Thank you!

[amitchandak]

@apc_123 , First add an index column in power query/edit query mode https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi

Then create a column like this in dax

date = date(2019,01,01) + [index]