List.Buffer manually

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.