topic Re: how to convert Data Type "Text" as Average in DAX Commands and Tips

how to convert Data Type "Text" as Average

Anonymous — Mon, 06 Feb 2023 15:09:48 GMT

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

Re: how to convert Data Type "Text" as Average

FreemanZ — Mon, 06 Feb 2023 15:35:46 GMT

hi Anonymous

try to convert it like:

TIMEVALUE([TAT])

Re: how to convert Data Type "Text" as Average

tamerj1 — Mon, 06 Feb 2023 17:23:11 GMT

Hi Anonymous
You may try creating a measure

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

Re: how to convert Data Type "Text" as Average

Anonymous — Tue, 07 Feb 2023 07:02:01 GMT

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

Re: how to convert Data Type "Text" as Average

FreemanZ — Tue, 07 Feb 2023 07:47:10 GMT

hi Anonymous

what result do you want?

Re: how to convert Data Type "Text" as Average

Anonymous — Tue, 07 Feb 2023 07:54:39 GMT

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!

Re: how to convert Data Type "Text" as Average

tamerj1 — Tue, 07 Feb 2023 08:07:19 GMT

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

Re: how to convert Data Type "Text" as Average

Anonymous — Tue, 07 Feb 2023 08:16:48 GMT

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"

Re: how to convert Data Type "Text" as Average

tamerj1 — Tue, 07 Feb 2023 08:39:52 GMT

Anonymous
Please try

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