Forum Discussion
Time Interval
Hello Every one,
I am new using power bi and need to cheek someting
I have a colum named "Delivery Time", and and two more called "Est_1" and "Est_2"
I need to know if the delivery time fits in the hours of Est 1 and est 2, for example
Delivery Time Est 1 Est 2
12:00 am 10:00 13:00
In this case, my delivery time is in the allowed range,
Is there a way to validate if the delivety time is between the other two??
Please I need help
Hi,
Create this calculated column formula
=AND([Delivery Time]>=[Est 1],[Delivery Time]<=[Est 2])
Hope this helps.
2 Replies
Hi,
Create this calculated column formula
=AND([Delivery Time]>=[Est 1],[Delivery Time]<=[Est 2])
Hope this helps.
How do we calculate the time interval between two dates in hours, excluding the weekends and US holidays?
