Forum Discussion
New table column with GenerateSeries()
Anonymous ,
If you consider it as a solution, please mark as a solution and kudos. So we can close this topic and help others.
Ricardo
Community ChampionHi Anonymous ,
I've created an example using Power Query, take a look on Advanced Editor.
File: Download PBIX
Ricardo
Hi camargos88 ,
First, thank you for replying.
if I correctly understand what you have done, you generated a column DateTime type for the forecast date?
But, in my case, I need to generate a list of date for each rows on a period.
If I take one row of your example:
Billing date: 01/01/2020
Recurrence: Month
Periodicity: 3
For this row, i'm waiting for a ForecastDate like this (a table): {04/01/2020; 07/01/2020; 10/01/2020; 01/01/2021; 04/01/2021; ...}
Is is possible to generate something like this for each rows of my tab?
Best regards,
- camargos88
Hi Anonymous ,
This code creates a range of dates, take a look at the steps on Power Query. First it get the recurrence for each row and generate a list of dates based on it. After that it expands the list on new rows, so the first 3 columns will be repeated with the new dates.
Do you need just the first date for each month or the range ?
Ricardo
Ok, i now understand what you did.
While doing a DateTime table column as I expect you duplicate each row with the forecast date I expected. It's clever.
I will try your adanced query on my project.
I will give you a feedback.
Thank again for the help
- camargos88
Anonymous ,
Doesn't work if you have a date table with all you dates ?
What do you want as result ?
Ricardo