How to copy column and create new column with that copy column inthe same table on a specific date?

[Abdullah-Ultra]

Hi Team,

How to copy one column (e.g Close date) and create new column with that copy column in the same table on a specific date every month.

Is that possible in power Bi.

Thanks in advance

Regards,

AJ

[ryan_mayu]

maybe you can try 

if(day(close date)=xxx, [closedate])