Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

time analysis

i have a start date and an end date, and i am trying to count how many days in each month, have each period, i use DATEDIFF, but this just give me the days for 1 month in example, the start date i...
Need Help
Tips and Tricks
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
7 years ago

parry2k thank you, that works for the total days, but didnt  give me the days for each month, I am trying creating columns for each month but i dont get to the correct result

parry2k's avatar
parry2k
Super User
7 years ago

Anonymous add two seperae column.

 

Days for Start Month = 
DAY( EOMONTH( Table2[Start], 0 ) )  


Days for End Month = 
DAY( EOMONTH( Table2[End], 0 ) )
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    parry2k it didnt work, the expression didnt allow me to select the date column

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Anonymous not sure why, can you share sample data?