Previous Month And Previous Quarter

[bhelou]

Hello , 
I have Dates table in Power Query , i need to add 2 new columns extracted from the date column , 
Column 1 : Start of previous month
Column 2 : Start of Previous Quarter

I need the previous Month and Quarter ,

Like the first cell to give me 01-Dec-97 and so on 

Many Thanks 

[v-zhangti]

Hi, @bhelou 

You can also try to solve the problem with DAX.

Column:

Start of Month = STARTOFMONTH('Table'[Date])

Start of previous month = EDATE([Start of Month],-1)

Start of Quarter = STARTOFQUARTER('Table'[Date])

Start of Previous Quarter = EDATE([Start of Quarter],-3)

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Vijay_A_Verma · Accepted solution]

For previous Start of month

= Date.StartOfMonth(Date.AddMonths([Date],-1))

For previous start of quarter

= Date.StartOfQuarter(Date.AddQuarters([Date],-1))

[bhelou]

Thank you worked  , Thanks for help