02-28-2018 13:51 PM - last edited 08-24-2018 05:47 AM
@Tan - Sure, you could do something like this:
NetWorkDays = VAR Calendar1 = CALENDAR(TODAY(),[Any Given Date]) VAR Calendar2 = ADDCOLUMNS(Calendar1,"WeekDay",WEEKDAY([Date],2)) RETURN COUNTX(FILTER(Calendar2,[WeekDay]<6),[Date])
If necessary, reverse the parameters for the CALENDAR function.
Proud to be a Datanaut!
I now face another issue I also want to Exclude holdiays.
I have created a "Holiday" table and also calculate working day using
I infact did i used Greg's solution and created another measure to calculate weekends and holidays and subtracted from the above solution.
I am receiving the same error. Did you ever figure out the solution?