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.

[PwerQueryKees · Accepted solution]

Do a 'reference' on the table you want to use. Then edit the new query to do whatever you like....

[Anonymous · Accepted solution]

Hi @lmpb1988,

Thank you for reaching out in Microsoft Community Forum.

Thank you @PwerQueryKees for the helpful response.

1. in the date column please right click on the query then select "Reference".

2. from the new query remove any unnecessary columns, and only keep the Date column (or the specific data you need).

3. You can now use this query to create your calendar or perform further actions.

Please continue using Microsoft community forum.

If you found this post helpful, please consider marking it as "Accept as Solution" and select "Yes" and give it a 'Kudos'. if it was helpful. help other members find it more easily.

Regards,
Pavan.

[Anonymous]

Hi @lmpb1988,

I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If the community member's answer your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.
If you need any further assistance, feel free to reach out.

Please continue using Microsoft community forum.

Thank you,
Pavan.

[Omid_Motamedise · Accepted solution]

On the query name, right click on use reference, then in the result query, right click on your desire column and pick drill down.

[Anonymous · Accepted solution]

Hi @lmpb1988,

Thank you for reaching out in Microsoft Community Forum.

Thank you @PwerQueryKees for the helpful response.

1. in the date column please right click on the query then select "Reference".

2. from the new query remove any unnecessary columns, and only keep the Date column (or the specific data you need).

3. You can now use this query to create your calendar or perform further actions.

Please continue using Microsoft community forum.

If you found this post helpful, please consider marking it as "Accept as Solution" and select "Yes" and give it a 'Kudos'. if it was helpful. help other members find it more easily.

Regards,
Pavan.

[PwerQueryKees · Accepted solution]

Do a 'reference' on the table you want to use. Then edit the new query to do whatever you like....