Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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.
Solved! Go to Solution.
Do a 'reference' on the table you want to use. Then edit the new query to do whatever you like....
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.
On the query name, right click on use reference, then in the result query, right click on your desire column and pick drill down.
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.
On the query name, right click on use reference, then in the result query, right click on your desire column and pick drill down.
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.
Do a 'reference' on the table you want to use. Then edit the new query to do whatever you like....