Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
lmpb1988
Frequent Visitor

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.

3 ACCEPTED SOLUTIONS
PwerQueryKees
Super User
Super User

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

View solution in original post

v-pbandela-msft
Community Support
Community Support

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.

View solution in original post

Omid_Motamedise
Super User
Super User

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

View solution in original post

4 REPLIES 4
v-pbandela-msft
Community Support
Community Support

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
Super User
Super User

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

v-pbandela-msft
Community Support
Community Support

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
Super User
Super User

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Top Solution Authors
Top Kudoed Authors