Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All,
I have a question about a creation of a True-False statement if a call is coming in during business hours or if it is outside business hours. During business hours is Monday to Friday between 8 AM and 5PM. Saterday + Sundays and national holidays are outside buisness hours.
I did manage to calculate the more simple true-false statement on just Business Days: BusinessDAYS = IF('# Calendar'[WeekdagNr]<6, TRUE())...that works correctly, however if I want to add as 2nd step the working hours element I get error message:
And I then 3rd step I also need to include the national holidays as outside business days ...
The value that determined if a national holiday are in table 'Nat Holidays NL' where field "Officiele vrije dag" should have value "Yes". The date and time of the connection are in another table called 'pbiTotalen'[Date] and 'pbiTotalen'[Time]
Appreciate if you can guide me me how to resolve... Thx for helping...D
Hi,
Some problem in the bracketing there. Before the <TIME, there should be ,1)
Thanks Ashish. That part is solved, but still interested to understand how to integrate the 3rd piece ...including also the fact that in case national holiday that is dureing weekdays this is regarded also as non working hours, so would like to see complete DAX function.
Hi,
Using the RELATED() or LOOKUPValUE() function, bring over to your Calendar table, the date of the public holiday from the Public Holiday table. Then modify your IF() formula to check if the Holiday column cell is blank or not.
Hope this helps.
Hi Ashish,
So how would complete DAX statement look like. Incorporating the earlier statement with the last part?
Thx D
Hi,
Share the link from where i can download your PBI file.
Hi Ashish,
Send you personally a link to location for downloading PBI file.
Thanks again for assistence.
Dave
User | Count |
---|---|
69 | |
43 | |
20 | |
20 | |
14 |
User | Count |
---|---|
123 | |
42 | |
39 | |
26 | |
24 |