locked
How to find the total number of the days in the current month or end of the day of the current month? RRS feed

  • 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

Answers

  • 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 Michael Amadi Tuesday, August 26, 2014 5:19 PM
    • Marked as answer by Charlie Liao Thursday, September 4, 2014 9:56 AM
    Tuesday, August 26, 2014 4:01 PM
    Answerer

All replies