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