Last day of Calendar month

[Anonymous]

Hi,

I'm trying to calculate prediction revenue for a calendar month (revenue average per day, that already calculated)*Last day of April, May and go on of this year (wanna show how far we are from our goals)

this is how I made it, but in March we have 31 days. 

February 28 days.

Need your HELP, please. 

Thanks.

[Anonymous · Accepted solution]

Hi @Anonymous ,

Try this,

DAY(EOMONTH(MIN(Table3[Date]),0)). Change the table and column names from the syntax.

I have tested and it is working fine.

Please accept this as solution, so that it will help other as well.

Regards,

Pavan Vanguri.

[Anonymous]

Thanks!

Works perfectly!