The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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] ) )
User | Count |
---|---|
70 | |
64 | |
62 | |
49 | |
28 |
User | Count |
---|---|
117 | |
75 | |
61 | |
54 | |
42 |