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.
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
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 |
---|---|
37 | |
25 | |
19 | |
14 | |
8 |
User | Count |
---|---|
69 | |
48 | |
44 | |
19 | |
15 |