March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
HI Joe, your suggestion wouldnt factor in weekends or holidays?
Thanks
I cannot believe how over complicated my DAX was !
This has solved it, thank so much @JoeBarry
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
83 | |
76 | |
62 | |
58 |
User | Count |
---|---|
141 | |
122 | |
105 | |
94 | |
90 |