How many days so far this month

[cocomy]

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, I want to show zero.  Thank you for your help as always!

Month             Days

1 Jan 2018       31

1 Feb 2018       28

1 Mar 2018      18

1 Apr 2018       0

All the best,

cocomy

[Zubair_Muhammad · Accepted solution]

@cocomy

[Zubair_Muhammad]

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 )

[Zubair_Muhammad · Accepted solution]

@cocomy

[cocomy · Accepted solution]

Zubair_Muhammad,

Perfectly worked. Thank you very much for your help!

All the best,

cocomy