Forum Discussion
Same day date difference resulting in negative value
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 ...
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
TomMartens
Super User
Super UserHey 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!