Need first of every month in M code

[klehar]

So i have the m code to generate dates between 2 dates which is this:

= List.Dates(#date(2017, 11, 1), 2500, #duration(1, 0, 0, 0))

However I dont want each day as 1 row.

I just want the start day of each month as the rows.

For example

1/1/2020 (read 1 Jan 2020)

1/2/2020 (read 1 Feb 2020) and so on

How can i do this in M?

[parry2k · Accepted solution]

@klehar try this:

List.Distinct(List.Transform(List.Dates(#date(2017, 11, 1), 2500, #duration(1, 0, 0, 0)), each Date.StartOfMonth(_)))

✨ Follow us on LinkedIn and  to our YouTube channel

Check my latest video on Filters and Sparklines https://youtu.be/wmwcX8HvNxc

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

[klehar]

That was quick

Thanks @parry2k 

Can you also explain the last characters ( _ )