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:
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.
Hi Imke,
I saw that function in my search to the solution also. It is working fine, but how am I able to generate new records for each table row?
Maarten Rasenberg