Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
How do I calculate a measure of a text column?
Calculated Column:
Solved! Go to Solution.
Hi @Anonymous,
Current power bi data model table not support duration types. According to your description and snapshot, it seems like you convert these value to text type to keeping the format.
For this scenario, these values are stored as text and you can't use common math aggregation functions on it. I'd like to suggest you convert them to total seconds instead.
Regards,
Xiaoxin Sheng
Hi @Anonymous,
Current power bi data model table not support duration types. According to your description and snapshot, it seems like you convert these value to text type to keeping the format.
For this scenario, these values are stored as text and you can't use common math aggregation functions on it. I'd like to suggest you convert them to total seconds instead.
Regards,
Xiaoxin Sheng
Hey @Anonymous ,
you cannot use an average for a text colum.
But you could use MAX('Table'[Reply time cal. hours]) to give back a text.