how to add string to measure

[Jane689]

I want to create a measure average time  such that when i used it in data card it shows text "seconds" next to the value (e.g 12 seconds) without converting the measure to text.

[v-rongtiep-msft · Accepted solution]

Hi @Jane689 ,

As far as I concerned, now Power BI does not support. You can submit an idea for it at   https://ideas.powerbi.com/ideas/   and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.

You can add a custom column with this formula (put this is the pop-up box when you hit Add Custom Column).

let
thislist = Text.Split([RunTime], " ")
in
if List.Count(thislist) = 4
then Number.FromText(thislist{0}) * 60 + Number.FromText(thislist{2})
else
if List.Contains(thislist, "s")
then Number.FromText(thislist{0})
else Number.FromText(thislist{0}) * 60

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[FreemanZ]

just end with &" seconds", try like

SUM(TableName[Seconds])&" seconds"