Forum Discussion
Average time, not earliest or latest
Anonymous,
It is because the data type is Time. PBI can not take the average of a time value.
Does the data in the column need to be Time (like 12:32pm) or does it just represent the minutes that users interacted? In which case the data type can be a number type and you can take the average of that.
Best,
Alan
Great observation! I was trying to figure out what it was going off of.
Anonymous you can use the simple DAX formula below to create a new calculated column to convert the current decimal column (0.020262458) back to minutes:
='Table'[Column] * 1440
1440 just represents the number of minutes in a day.
Best,
Alan
Solution SupplierAnonymous,
Can you post some sample data of that column so I can see what the data looks like? Definitely has something to do with the data type.
Thanks,
Alan
The decimal number you are getting is basically a fraction of a day. You should be able to use a DAX formula to convert it into a time. This page might be helpful: