cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
MarinaKats Frequent Visitor
Frequent Visitor

Last day of Calendar month

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)

image.png

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

February 28 days.

 

Need your HELP, please. 

Thanks.

 

 

 

 

 

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Last day of Calendar month

Hi @MarinaKats ,

 

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.
2 REPLIES 2

Re: Last day of Calendar month

Hi @MarinaKats ,

 

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.
MarinaKats Frequent Visitor
Frequent Visitor

Re: Last day of Calendar month

Thanks!

 

Works perfectly!