monaco88New Member3 years agoSolvedAdding aliases 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 ou...Show Moretamerj13 years agoHi monaco88 please try EVALUATESELECTCOLUMNS (FILTER (SUMMARIZE ( 'Items', 'Items'[ItemID], "Cost", SUM ( 'Items'[Cost] ) ),[Cost] > 10),"NewName", [ItemID],"Cost", [Cost])
tamerj13 years agoHi monaco88 please try EVALUATESELECTCOLUMNS (FILTER (SUMMARIZE ( 'Items', 'Items'[ItemID], "Cost", SUM ( 'Items'[Cost] ) ),[Cost] > 10),"NewName", [ItemID],"Cost", [Cost])
tamerj13 years agoHi monaco88 please try EVALUATESELECTCOLUMNS (FILTER (SUMMARIZE ( 'Items', 'Items'[ItemID], "Cost", SUM ( 'Items'[Cost] ) ),[Cost] > 10),"NewName", [ItemID],"Cost", [Cost])
tamerj1Community Champion3 years agoHi monaco88 please try EVALUATESELECTCOLUMNS (FILTER (SUMMARIZE ( 'Items', 'Items'[ItemID], "Cost", SUM ( 'Items'[Cost] ) ),[Cost] > 10),"NewName", [ItemID],"Cost", [Cost])
Related contentMLFlow - Problem with aliases and metricsAliasing ValuesAdding columnsAdding a columnMobile App - Adding Multiple Dashboards into One
