Adding aliases

[monaco88]

Hi,

I'm trying to add the alias "ItemID".... for 'Items'[ItemID].... to the below query:  I know this should be straightforward but I've been looking at this for some time and unable to figure it out.  Thanks in advance!

EVALUATE
  FILTER(
    SUMMARIZE(
    'Items',
    'Items'[ItemID],
    "Cost", SUM('Items'[Cost])
  ),
  [Cost] > 10
)

[tamerj1 · Accepted solution]

Hi @monaco88 

please try

EVALUATE
SELECTCOLUMNS (
FILTER (
SUMMARIZE ( 'Items', 'Items'[ItemID], "Cost", SUM ( 'Items'[Cost] ) ),
[Cost] > 10
),
"NewName", [ItemID],
"Cost", [Cost]
)

[monaco88]

That works.  Thanks!

[eliasayyy]

EVALUATE

SELECTCOLUMNS (

  'Items',

    "item ID", 'item'[item Id],

)

This will help you name an alias