The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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 |
---|---|
69 | |
64 | |
62 | |
55 | |
28 |
User | Count |
---|---|
112 | |
80 | |
65 | |
48 | |
38 |