How to rollover the last date of the month to the first date of next month

[PBI_newuser]

Hi,

I would like to create new date column to rollover all the last day of the month to first date of next month.

How to do this?

For example: 

Date_Old	Date_New
31/3/2020	1/4/2020
30/6/2020	1/7/2020
23/7/2020	23/7/2020
14/8/2020	14/8/2020

[pranit828 · Accepted solution]

HI @PBI_newuser 

Craete a new column as below

Date_new = IF(table'[date_old] = EOMONTH(table'[date_old]),table'[date_old]+1,table'[date_old])