Forum Discussion

lmpb1988's avatar
lmpb1988
Frequent Visitor
1 year ago
Solved

List.Buffer manually

I know that the list.buffer function allows you to extract data from another table, but I would like to know if it is possible to do this manually, that is, instead of introducing code.

In short, I have a table with several pieces of data, including a date column, and I wanted to extract this date column into a new query and work from the new query to create a calendar.
I tried the "add as new query" command and it works, but it copies all the steps I did in the initial table and I didn't want that to be visible.

  • you can extract a single column from a different source, like

     

    let 

        Source = Query1[Column1]

    in

       Source

     

    which gives you a list.

     

    Note that this has nothing to do with list buffers. That's a different feature.

4 Replies

  • you can extract a single column from a different source, like

     

    let 

        Source = Query1[Column1]

    in

       Source

     

    which gives you a list.

     

    Note that this has nothing to do with list buffers. That's a different feature.

    • v-aatheeque's avatar
      v-aatheeque
      Community Support

      Hi lmpb1988 

      Has the response from lbendlin     resolved your issue?

      If so, please consider marking the helpful reply as the accepted solution—this helps other community members with similar questions find answers more easily.

      Thank you for being a valued member of the Microsoft Fabric Community Forum!

      • v-aatheeque's avatar
        v-aatheeque
        Community Support

        Hi lmpb1988 ,

        Has the response from lbendlin resolved your issue?

        If it did, please consider marking the helpful reply as the accepted solution—this helps other community members with similar questions find answers more easily.

        Thank you for being a valued member of the Microsoft Fabric Community Forum!