Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Measure text string

How do I calculate a measure of a text column?  Calculated Column: Reply time cal. hours = VAR currentNum = 'Table'[REPLY_TIME_IN_CALENDAR_MINUTES] RETURN RIGHT("0" & INT (currentNum/60),2) & ...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

    Aggregating Duration Time 

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.

Aggregating Duration Time 

Regards,

Xiaoxin Sheng