Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
I have written one DAX , this dax will give me ,
Solved! Go to Solution.
@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
| User | Count |
|---|---|
| 56 | |
| 42 | |
| 30 | |
| 18 | |
| 16 |
| User | Count |
|---|---|
| 70 | |
| 58 | |
| 38 | |
| 22 | |
| 22 |