Use TRIM with SUMARIZE

[cristianml]

Hi,

I want to TRIM the text from the Sumarized values when I create a table. 

How or where can I add TRIM in this case ?

_List Service Dimension =

VAR V1 = SUMMARIZE(Sales,Sales[Service Dimension])

VAR V2 = SUMMARIZE(Plan,Plan[Service Dimension])

VAR V3 = SUMMARIZE('Rev CCI','Rev CCI'[Service Dimension])

VAR V4 = SUMMARIZE('CI','CI'[Service Dimension])

RETURN

DISTINCT(UNION(V1,V2,V3,V4))

Thanks

[Ahmedx · Accepted solution]

probably so

Table 2 = VAR V1 = SUMMARIZE(Sales,Sales[Service Dimension])
VAR V2 = SUMMARIZE(Plan,Plan[Service Dimension])
VAR V3 = SUMMARIZE('Rev CCI','Rev CCI'[Service Dimension])
VAR V4 = SUMMARIZE('CI','CI'[Service Dimension])
RETURN

SELECTCOLUMNS(
ADDCOLUMNS(DISTINCT(UNION(V1,V2,V3,V4)),
"@Service Dimension",TRIM([Service Dimension])),
"Service Dimension",[@Service Dimension])

[FreemanZ]

hi @cristianml 

Your Service Dimention column seems already trimmed, what do you expect?