Calculate days in selected month in slicer

[Unmona_D]

Hello, 

I want to build a measure to calculate the days in the selected month. Please help.

[amitchandak]

@Unmona_D ,

In case it coming from date calendar

1.  day(eomonth(maxx(allselected(Date), Date[Date]),0))

2. Count(Date[date])

In case this month without a date. we need to additional coding

[Unmona_D]

Hi Amit,

Thank you. But this doesnt come from a date calendar. It is start of each month. Hence, the issue. Is there a way that the measure calculates the number of days based on the slicer input?

[amitchandak · Accepted solution]

@Unmona_D , Try like

day(eomonth(maxx(allselected(Table), Table[Start Date]),0))

[Mariusz]

Hi @Unmona_D 

Just count rows of your date table like: COUNTROWS( dates ) 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Unmona_D]

Thank you Mariusz. But the issue is this doesnt come from a uniform date calendar (with all dates included for a month)