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.
Hi,
Having no luck modifying this formula to get around the error.
= if [Cancelled] = 1 and [logIn time] <= [dueIn] + 1/24 * .25 and [logIn time] >= [dueIn] - 1/24*.25 then 1
else 0
Expression.Error: We cannot apply operator + to types Time and Number.
Details:
Operator=+
Left=18:00:00
Right=0.010416667
Both columns dueIn & logIn time are in time format.
Solved! Go to Solution.
@Qotsa You will like have to convert your time to decimal number. https://docs.microsoft.com/en-us/powerquery-m/number-from
@Qotsa You will like have to convert your time to decimal number. https://docs.microsoft.com/en-us/powerquery-m/number-from
Thks Greg. That did the trick.
You can get numbers to evaluate by using Duration.TotalMinutes([duein] - [login time]) for example. You can build your logic around that result.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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.