Forum Discussion
add column date self-incremental
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!
3 Replies
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
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!
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]
