Reverse date to first day of month in M Language

[Anonymous]

Hello friends,

I have a column looks like this

02/07/2020

05/06/2019

13/12/2015

30/01/2017

I want to convert to

01/07/2020

01/06/2019

01/12/2015

01/01/2017

I am currently using an ugly way of achieve

1. Convert date to text,

2. Trim the first two digit,

3. Concat with "01"

4. Convert it back to date.

Just want to know is there an elegant way?

[GilbertQ · Accepted solution]

Hi there

If you create a new Custom Column you can put in the following

Date.StartOfMonth([Column Name])

[Ashish_Mathur]

Hi,

This calculated formula in DAX will also work

=EOMONTH(Data[Date],-1)+1

[AllisonKennedy · Accepted solution]

@Anonymous  There is also a button for this in the Add Column tab in Power Query: 

[GilbertQ · Accepted solution]

Hi there

If you create a new Custom Column you can put in the following

Date.StartOfMonth([Column Name])