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