first day of the month available

[LBA1202]

Hi there,
I am trying to flag the first day of the month available in a data source which is the concatenation of several excel files. This is to plot a monthly evolution over time.

Not finding a simple solution, I submit this subject to you.

Someone would have any idea?

Thank you in advance for your help

[v-jingzhang · Accepted solution]

Hi @LBA1202 

Do you have a Date column in your table? If you have a Date column, you can add a custom column in Power Query Editor with Date.StartOfMonth([Date]). Put your date column in Date.StartOfMonth() function. 

Or use DAX to create a new column

Month Start Date = STARTOFMONTH('your table name'[Date])

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.