Forum Discussion
Avarage for Dates,
Guys, I have a table like that and the only thing i need is to make a chart when the time will be showed as avarege of each ID like we do in e.xcel
Data i have
| ID | TIME |
| A12 | 07:00:00 |
| A13 | 07:40:00 |
| A12 | 07:30:00 |
| A15 | 07:15:00 |
| A16 | 08:12:00 |
| A17 | 07:17:00 |
| A12 | 08:06:00 |
| A16 | 07:24:00 |
| A13 | 08:09:00 |
| A16 | 08:21:00 |
| A13 | 08:13:00 |
what I want :
id avg
| A12 | 07:32:00 |
| A13 | 08:00:40 |
| A15 | 07:15:00 |
| A16 | 07:59:00 |
| A17 | 07:17:00 |
Hi Anonymous
You can try this Measure, just make sure you format the to "HH:mm:ss" as highlighted below.
CONVERT() is a new function introduced in sep - 2019 release.
Measure = CONVERT( AVERAGE( 'Table'[TIME] ), DATETIME )
Or try the below, however, the FORMAT() function will return text instead.
Measure 2 = FORMAT( AVERAGE( 'Table'[TIME] ), "HH:mm:ss" )
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
1 Reply
Hi Anonymous
You can try this Measure, just make sure you format the to "HH:mm:ss" as highlighted below.
CONVERT() is a new function introduced in sep - 2019 release.
Measure = CONVERT( AVERAGE( 'Table'[TIME] ), DATETIME )
Or try the below, however, the FORMAT() function will return text instead.
Measure 2 = FORMAT( AVERAGE( 'Table'[TIME] ), "HH:mm:ss" )
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.