How to add new column with end of month date based on today's date

[Anonymous]

Hi all, can someone please tell me how to add a column with end of month date in power bi query.

The month is based on today's date.  So if today is 12/04/2021 i need EOM date to be 30/04/2021.

thank you

[achinchilla]

Hi.  I need to have a new column with the last date from another column, how could I do that?

[V-pazhen-msft · Accepted solution]

@Anonymous 
Add the following custom column, then convert the data type to Date only.
= Date.EndOfMonth(DateTime.LocalNow())

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Awesome, it worked! Thanks Paul 🙂

[ERD]

Hello @Anonymous ,

There is a Date.EndOfMonth function in Power Query. Have a look at the article below:

https://docs.microsoft.com/en-us/powerquery-m/date-endofmonth 

So you can add custom column with the code:

=Date.EndOfMonth([Date])

Did I answer your question? Mark my post as solution!