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.
Hello Community,
I have created networkdays between two days (it includes holidays and excludes weekends) by using this:
Solved! Go to Solution.
Hi @Anonymous ,
we can create such a measure to meet your requirement.
NetWorkDaysENDExcludeHoliday = VAR Calendar1 = CALENDAR ( MIN ( 'Query1'[END] ), MAX ( 'Query1'[FYEND] ) ) VAR Calendar2 = ADDCOLUMNS ( Calendar1, "WeekDay", WEEKDAY ( [Date], 2 ) ) RETURN SUMX ( FILTER ( Calendar2, [WeekDay] <= 5 ), IF ( CONTAINS ( holidays, 'holidays'[Date], [date] ), 0, 1 ) )
BTW, pbix as attached.
Best regards,
Community Support Team _ DongLi
If this post helps, then please consider Accept it as the solution to help the other members find it more
Hi @Anonymous ,
we can create such a measure to meet your requirement.
NetWorkDaysENDExcludeHoliday = VAR Calendar1 = CALENDAR ( MIN ( 'Query1'[END] ), MAX ( 'Query1'[FYEND] ) ) VAR Calendar2 = ADDCOLUMNS ( Calendar1, "WeekDay", WEEKDAY ( [Date], 2 ) ) RETURN SUMX ( FILTER ( Calendar2, [WeekDay] <= 5 ), IF ( CONTAINS ( holidays, 'holidays'[Date], [date] ), 0, 1 ) )
BTW, pbix as attached.
Best regards,
Community Support Team _ DongLi
If this post helps, then please consider Accept it as the solution to help the other members find it more
Hello guys,
Any Suggestions Please...
Thank you in advance
Regards,
B V S S
Hello @Anonymous
I have attached a sample file where my Dates table has a column "IsWorkingDay" that is = FALSE on weekends and holidays. Using that and the dates you are comparing you can just do a count of rows with some filtering.
WorkingDays = VAR LowEnd = FIRSTDATE ( 'Table'[StartDate] ) VAR HighEnd = LASTDATE ( 'Table'[EndDate] ) RETURN CALCULATE ( COUNTROWS ( Dates ), Dates[Date] >= LowEnd && Dates[Date] <= HighEnd, Dates[IsWorkingDay] = TRUE )
Hi @jdbuchanan71 ,
Thank you for your response.. I tried but it's not working properly for my case. May be some other cases it will work
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |