@Anonymous Try:
Measure =
VAR __Dates = 'Dates' // your date table
VAR __Table =
ADDCOLUMNS(
__Dates,
"__WeekDay", WEEKDAY([Date], 2)
)
VAR __Result = COUNTROWS(FILTER(__Table, [__WeekDay] < 6))
RETURN
__ResultFollow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
