Forum Discussion

mrasenberg's avatar
mrasenberg
Regular Visitor
9 years ago
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:   ...
Need Help
  • ImkeF's avatar
    ImkeF
    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:

     

mrasenberg's avatar
mrasenberg
Regular Visitor
9 years ago

Thank you in advance!

ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
9 years ago

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.