Iterate over all dates in a month from start date forward

[kressb]

Hello,

Right now I receive a chart like this:

I want to use PowerQuery to expand the dates start with the start date so i have every day with the object from the start date forward, ex:

*they would continue on for future months, this is just a small example.

Does anyone know how to get the dates in the month to iterate in PowerQuery?

[v-pnaroju-msft]

Hi kressb,

We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.

If our response was helpful, please mark it as the accepted solution and provide kudos, as this helps the broader community.

Thank you.

[v-pnaroju-msft]

Hi kressb,

We wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.

If you found our response useful, kindly mark it as the accepted solution and provide kudos to guide other members.

Thank you.

[v-pnaroju-msft]

Hi kressb,

We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.

If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.

Thank you.

[SundarRaj]

Hi @kressb , here's another solution for you to look at. I'll attach the image of the output and the code used. Thanks!

Here's the code:
let
Source = Excel.CurrentWorkbook(){[Name="Table3"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Dates", type date}, {"Object", type text}}),
List = Table.TransformColumns(#"Changed Type",{"Dates", each {Number.From(_)..Number.From(Date.EndOfMonth(_))}}),
ListOfDates = Table.TransformColumns(List,{"Dates", each List.Transform(_, each Date.From(_))}),
Expand = Table.ExpandListColumn(ListOfDates, "Dates")
in
Expand

[v-pnaroju-msft · Accepted solution]

Thankyou, @jgeddes, for your response.

Hi @kressb,

We appreciate your inquiry through the Microsoft Fabric Community Forum.

Please find attached the screenshot and the PBIX file, which may assist in resolving the issue:

If you find our response helpful, we kindly request you to mark it as the accepted solution and provide kudos. This will aid other community members who may have similar queries.

Thank you.

[jgeddes]

Add a column and use List.Dates.
An example code would be...

Table.AddColumn(previousStep, "dateList", each List.Dates([StartDate], Number.From(Date.EndOfMonth([StartDate])-[StartDate]) + 1, #duration(1,0,0,0)), type list)

Expand that column to new rows and then delete the original StartDate column (if no longer needed.)