Forum Discussion
Solved
Countx With date filter
I have written one DAX , this dax will give me , this will return count of weekends in selected month, IsWeekend is my column with true and false value in that , this is giving me right result but ...
bilalkhokar73 , Try for today's month
countx(FILTER(tm_date,tm_date[IsWeekend]=TRUE() && eomonth(tm_date[Date],0) = eomonth(today(),0)),tm_date[Date])
use maxx(allselected(tm_date), tm_date[Date]) for selected date, in place of today
bilalkhokar73 , Try for today's month
countx(FILTER(tm_date,tm_date[IsWeekend]=TRUE() && eomonth(tm_date[Date],0) = eomonth(today(),0)),tm_date[Date])
use maxx(allselected(tm_date), tm_date[Date]) for selected date, in place of today
thank you worked for me