Forum Discussion
Dynamically generate table rows for each row
- 9 years ago
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:
OK, well that was the easy part, now I'll have to try to figure out how to accomplish it!
Thank you in advance!
- ImkeF9 years agoCommunity Champion
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.
- mrasenberg9 years agoRegular Visitor
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
- ImkeF9 years agoCommunity Champion
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: