how to get total number of dates in particular month for selected date

[jay_patel]

Hi all 

Looking for a dax to caculate total days for the month of selected date. Here attaching Screenshot for your reference. selected date is '09 june 2021' and i want total number of dates for the month "june".

[amitchandak · Accepted solution]

@jay_patel ,

total daty = day(eomonth(selectedvalue(Date[Date]),0))

Work Day =
COUNTROWS(FILTER(ADDCOLUMNS(calendar(eomonth(selectedvalue(Date[Date]),-1) +1, eomonth(selectedvalue(Date[Date]),0)),"WorkDay", if(WEEKDAY([Date],2) <6,1,0)),[WorkDay] =1))