Forum Discussion
Solved
Dynamically generate table rows for each row
Hi all, Being quite new to Power Bi, I'm reaching out to this community. What I'm trying to achieve is to dynamically generate table rows for each date in a date range. The source: ...
By expanding the list-column that has been generated : The last column "Custom" has been created by the formula -> you see the list and expand it with the double-arrow in the headers:
So, would your expected result be:
01-11-2016 7069 02-11-2016 7069 03-11-2016 7069 04-11-2016 7069 01-11-2016 7070 02-11-2016 7070 03-11-2016 7070 04-11-2016 7070 31-10-2016 7071 01-11-2016 7071 02-11-2016 7071 03-11-2016 7071 04-11-2016 7071 06-11-2016 7072 07-11-2016 7072 08-11-2016 7072 09-11-2016 7072 10-11-2016 7072 11-11-2016 7072
If not, please provide what you are looking to achieve.
Hi Smoupre,
That is correct!
Regards,
Maarten
OK, well that was the easy part, now I'll have to try to figure out how to accomplish it!
Thank you in advance!
If I may step in here - there is a function in M for it: List.Dates, which you put into a CustomColumn like this:
List.Dates([StartDate], [DateDifference]+1, #duration(1,0,0,0))
This produces a list that you can then expand.