Forum Discussion

cocomy's avatar
cocomy
Icon for Resolver I rankResolver I
8 years ago
Solved

How many days so far this month

Hi All,   Could you please help me to build fomular for this?   I want to have no of days finished each moth. So it is 18 Mar  today, I want to get 18 in 1 Mar column. April has not started yet...
Need Help
  • cocomy's avatar
    cocomy
    8 years ago

    Zubair_Muhammad,

     

    Perfectly worked. Thank you very much for your help!

     

    All the best,

    cocomy

Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Hi cocomy

 

You can try this calculated column

 

days =
VAR MonthEnd =
    EOMONTH ( Table1[Month], 0 )
VAR EndDate =
    IF ( MonthEnd > TODAY (), TODAY (), MonthEnd )
RETURN
    IF ( EndDate > Table1[Month], DATEDIFF ( Table1[Month], EndDate, DAY ) + 1, 0 )