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.
I have a table that has 'Created' date/time and 'Updated' date/time.
I can calculate the DATEDIFF, but need to also show Business Days Only.
I have a CalendarTbl[Date] with relationship to below data.
Example of data
Created Updated
03-05-2021 11:22:09 AM |03-05-2021 02:53:52 PM
03-02-2021 09:41:13 PM | 04-05-2021 09:40:50 PM
02-24-2021 09:13:02 AM | 04-12-2021 02:52:56 PM
02-16-2021 04:09:22 PM | 02-22-2021 10:44:02 AM
02-15-2021 04:08:22 PM | 03-31-2021 11:14:54 AM
Any help would be greatly appreciated.
tks/
Solved! Go to Solution.
@Anonymous , Something like this
Work Day = COUNTROWS(FILTER(ADDCOLUMNS(CALENDAR(Table[Created],Table[updated]),"WorkDay", if(not(WEEKDAY([Date],1) in {1,7}),1,0)),[WorkDay] =1))
Thank you Amit. Your video was helpful and I will look at your other videos.
One question... how would that Sample column formula work if Sunday=1 and Saturday=7?
I am very new to DAX and just trying to learn as I go.
tks/
@Anonymous , Something like this
Work Day = COUNTROWS(FILTER(ADDCOLUMNS(CALENDAR(Table[Created],Table[updated]),"WorkDay", if(not(WEEKDAY([Date],1) in {1,7}),1,0)),[WorkDay] =1))
Thank you so much! Worked great!
@Anonymous , Refer my Video on the same if that can help
https://www.youtube.com/watch?v=Qv4wT8_P-AA
Sample column formula
Work Day = COUNTROWS(FILTER(ADDCOLUMNS(CALENDAR(Table[Created],Table[updated]),"WorkDay", if(WEEKDAY([Date],2) <6,1,0)),[WorkDay] =1))
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
14 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |