Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I have a custom column which calculates Networkdays between 2 dates, and it will only calculate if a start date and end date are present, otherwise it shows as blank. What I cannot seem to get it to do is provide a "0" value if Start Date and End Date are the same day. I have tried to append "-1" at the end of my DAX but that just returns a -1 on values that are blank.
This is my DAX:
Solved! Go to Solution.
Hi @Jays_D
You can try this.
Networkdays = DATEDIFF(client_table[Client Meeting Date], client_table[picked up date], DAY)
Thanks
Joe
If using network days to exclude weekends, any suggestions rather than using datediff?
Hi @Jays_D
You can try this.
Networkdays = DATEDIFF(client_table[Client Meeting Date], client_table[picked up date], DAY)
Thanks
Joe
I cannot believe how over complicated my DAX was !
This has solved it, thank so much @JoeBarry