Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
This measure is giving me no of weekend in current month Which is = 4
, Now today is 22 June , I want no. of weekend till date which should be 3
WeekendCOunt =
countx(FILTER(dateA,date[IsWeekend]=TRUE() && eomonth(dateA[Date],0) = eomonth(today(),0)),dateA[Date])
This measure is giving me no of weekend in current month , Now today is 22 JUne , i want no of weekend till date
Answer will be 3
how to make it through
Solved! Go to Solution.
@bilalkhokar73 I added another condition, please try:
COUNTX (
FILTER (
dateA,
date[IsWeekend] = TRUE ()
&& EOMONTH ( dateA[Date], 0 ) = EOMONTH ( TODAY (), 0 )
&& dateA[Date] <= TODAY ()
),
dateA[Date]
)
Thank you , it solved
@bilalkhokar73 I added another condition, please try:
COUNTX (
FILTER (
dateA,
date[IsWeekend] = TRUE ()
&& EOMONTH ( dateA[Date], 0 ) = EOMONTH ( TODAY (), 0 )
&& dateA[Date] <= TODAY ()
),
dateA[Date]
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |