Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
Appreciate if you can help me with the following:
1.) Is there a DAX in counting the past number of days in the current month excluding today and Sundays?
2.) Is there a DAX to count the remaining days of the current month excluding today, Sundays, and past days.
Best regards,
Mark
Hi @markefrody ,
try these measures:
Days Before Today = CALCULATE(
COUNTROWS('Date'),FILTER(
'Date','Date'[Date]<TODAY() && MONTH('Date'[Date])=MONTH(TODAY()) && WEEKDAY('Date'[Date])<>7)
)
Days After Today = CALCULATE(
COUNTROWS('Date'),FILTER(
'Date','Date'[Date]>TODAY() && MONTH('Date'[Date])=MONTH(TODAY()) && WEEKDAY('Date'[Date])<>7)
)
Hope it helps.
Cheers,
Marco
Hi Marco,
Thank you for the measure. I have tried using it but the number of days are not computing properly. I have attached the sample data for your reference.
Best regards,
Mark V
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |