Using LEFT function in SUMMARIZECOLUMNS statement

Question

Hi,&nbsp;I'm trying to pull the leftmost 10 characters of the Description field, below.&nbsp; How would I change the below to do so?&nbsp; I know this should be pretty basic but I've been working on it for some time and can't figure it out.&nbsp;&nbsp;&nbsp;DEFINE VAR _items =&nbsp;SELECTCOLUMNS (&nbsp;&nbsp;&nbsp;&nbsp;SUMMARIZECOLUMNS (&nbsp;&nbsp;&nbsp;&nbsp;Items[ID],&nbsp;&nbsp;&nbsp;&nbsp;Items[Color],&nbsp;&nbsp;&nbsp;&nbsp;Items[Description],&nbsp;&nbsp;&nbsp;&nbsp;FILTER (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Items,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Items[Color] = "Green"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)),--Assign aliases:"ID", Items[ID],"Color", Items[Color],"Description", Items[Description])EVALUATE _Items

tamerj1 · Accepted Answer

Hi&nbsp;Anonymous&nbsp;LEFT function will do
DEFINE
    VAR _items =
        SELECTCOLUMNS (
            SUMMARIZECOLUMNS (
                Items[ID],
                Items[Color],
                Items[Description],
                FILTER ( Items, Items[Color] = "Green" )
            ),
            --Assign aliases:
            "ID", Items[ID],
            "Color", Items[Color],
            "Description", LEFT ( Items[Description], 10 )
        )

EVALUATE
_Items

Forum Discussion

Using LEFT function in SUMMARIZECOLUMNS statement

2 Replies

Related content

summarizecolumns and if statement

Summarize VS Summarizecolumn function in DAX

Alias on SummarizeColumns

DAX query with SUMMARIZECOLUMNS - Optimization

OR Statement ?