# How to find the total number of the days in the current month or end of the day of the current month?

• ### Question

• Hi,

I just want to get the total number of the days of current month.

The reason why i am asking that i have Monthly target data but i wanna find daily target so,i need total numbers days of current month in order to divide with the monthly target.

Monthly target : 3400

Daily Target = 3400/total number of the days(how to find by using DAX?)

i would be really grateful if you give me appropriate answer.

Regards,

Robert

Tuesday, August 26, 2014 9:11 AM

• You can create a new Calculated Column in the table that contains dates using this:

=EOMONTH(TableName[Dates], 0) - EOMONTH(TableName[Dates], -1)
Just update the TableName[Dates] to the appropriate table and column in your model.

• Proposed as answer by Tuesday, August 26, 2014 5:19 PM
• Marked as answer by Thursday, September 4, 2014 9:56 AM
Tuesday, August 26, 2014 4:01 PM

### All replies

• Tuesday, August 26, 2014 9:29 AM