Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
hello everyone, I need a measure that brings me the time extracted from a date/time field, but when I did that the result is bringing the value as text and I needed the result as a number to compare it later if it is greater or less than a value.
thank you for the help
Solved! Go to Solution.
Instead of FORMAT, you can write
Time = TIMEVALUE ( MAX ( Table1[DateTime] ) )
Instead of FORMAT, you can write
Time = TIMEVALUE ( MAX ( Table1[DateTime] ) )