List.Buffer manually

[lmpb1988]

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.

[lbendlin · Accepted solution]

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]

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]

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!

[v-aatheeque]

Hi @lmpb1988 ,

Did @lbendlin  response resolve your issue?

If yes, 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!