Forum Discussion

cristianml's avatar
cristianml
Icon for Post Prodigy rankPost Prodigy
3 years ago
Solved

Use TRIM with SUMARIZE

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

Data Protection
General Comment
Need Help
Tips and Tricks
Tutorial Requests
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    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])

2 Replies

  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper User
    3 years ago

    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])