Help with M expression - Create custom column based on Date

Question

Hi,&nbsp;I need help writing an M expression for a custom column in Power Query.&nbsp;&nbsp;I have a column with dates called "Initial Date". Depending on the quarter in which the date falls I want to create a new custom column "Desired Date" that gives the first day of the next quarter. Quarters are running from Jan-Mar etc. In the example below 2022-01-01 should return 2022-04-01 and 2022-05-03 should return 2022-07-01.&nbsp;&nbsp;Thank you!&nbsp;

amitchandak · Accepted Answer

Anders_G , Try one of the two in power query as a new column 
&nbsp;
Date.AddQuarters([Column],1)
&nbsp;
&nbsp;
Date.StartOfQuarter(Date.AddQuarters([Column],1))

Forum Discussion

Help with M expression - Create custom column based on Date

2 Replies

Related content

How creating a Python custom library

Help!!! Expression Error

Regular expression

Creating a custom column

create custom column concatenated