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
Community 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.

 

  • mrasenberg's avatar
    mrasenberg
    Regular Visitor
    9 years ago

    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

    • ImkeF's avatar
      ImkeF
      Community Champion
      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:

       

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        9 years ago

        Thanks ImkeF, I hope you know that you are ALWAYS welcome to step in and provide the answer!! :) If I had figured out that it was an "M" problem I would most likely have invoked you anyway but I got pulled away and just got back to this thread now. I had pretty much determined that it wasn't going to be possible to do this in DAX but that's as far as I got!

         

        function invokeImkeF(q) {
    a = magic(q);
    return a;
}
invokeImkeF("Dynamically generate table rows for each row");

        It's just psuedo-code right now...