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.
Hello PBi Community - So I have the formula below which works great for calculating the number of weekdays between two dates. I then use the result of this to tell me whether a shipment is on time, or late.
One strange issue I have is that if the due date and the ship date fall on the exact same date, the result = -1. Ideally, it should just say 0.
Any idea how to fix this?
Solved! Go to Solution.
Hey @Anonymous ,
as both dates are equal, the FALSE branch will be evaluated, and this means that the 1 row will be multiplied with -1
Regards,
Tom
Hey @Anonymous ,
as both dates are equal, the FALSE branch will be evaluated, and this means that the 1 row will be multiplied with -1
Regards,
Tom
Thanks Tom....I realized I just needed to add an = sign to my first statement....then it made the days where the due date and ship date were the same to say "1" instead of "-1". Which technically is correct as the formula is counting the actual number of weekdays in the date range...which in those cases is "1" (not Zero). Thanks for pointing me in the right direction!
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |