Forum Discussion
TIME/Duration conversion & averages
Ok i always seem to struggle with time in BI and I've a project that its quite critical I can display values as hours and minutes, not deciaml time and not just whole minutes... I have a tabel th...
Hi astarkey,
How about creating a tooltip based on a measure? Example:
tooltip = FORMAT ( DIVIDE ( AVERAGE ( 'Table'[Time in Minutes] ), 60 ), "HH:MM" )
Thanks for the reply
I can get the tooltip to show the correct time already but I don't think thats going to be my solution.... I really need the data