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

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