Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

how to convert Data Type "Text" as Average

Hello Everyone!

I'm having a hard time to get the average of Turn Around Time (TAT) that is in the "Text Format"

my TAT format is like this "hh:mm:ss" and once i visualize this using CARD, there's no option to make it as "Average"

 

Note: there is no "Average" option in "Fields" that's

Nelzkie09_0-1675696171422.png

 

8 REPLIES 8
tamerj1
Super User
Super User

Hi @Anonymous 
You may try creating a measure

Average TAT = AVERAGEX ( 'Table', TIMEVALUE ( 'Table'[TAT] ) )
Anonymous
Not applicable

It's working but not the result i wanted. still, thank you!

hi @Anonymous 

what result do you want?

Anonymous
Not applicable

the result i wanna get is to show in the card the Average Hours and Minutes.

for e.g. when i click the table that contains 1 data, and Turn-Around-Time is like this "08:23"-8 hours and 23 minutes, it should also reflect in the card as Average.

 

thanks!

@Anonymous 
Please provide sample data a example along with the expected result(s).

Anonymous
Not applicable

i want this column to be reflected in the CARD as Average but it gives me error when trying to do this as Average

Note: that Data Type is in "Text"

Nelzkie09_0-1675757736777.png

 

@Anonymous 
Please try

Average TAT =
AVERAGEX (
    FILTER ( 'Table', 'Table'[TAT] <> BLANK () ),
    TIMEVALUE ( 'Table'[TAT] )
)
FreemanZ
Super User
Super User

hi @Anonymous 

try to convert it like:

TIMEVALUE([TAT])

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.