The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
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
Solved! Go to Solution.
Hi,
Create this calculated column formula
=AND([Delivery Time]>=[Est 1],[Delivery Time]<=[Est 2])
Hope this helps.
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?
Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.
User | Count |
---|---|
158 | |
106 | |
96 | |
83 | |
75 |
User | Count |
---|---|
154 | |
137 | |
131 | |
81 | |
62 |