DAX Addcolumns

[dicken]

Can someone help with addcolumns, I have SUMMARIZE;

EVALUATE
SUMMARIZE (
    Table1,
    Table1[Date],
    Table1[Item],
    "JA", CALCULATE ( SUM ( Table1[Units] ), ALL ( Table1 ) ),
    "RA", SUM ( Table1[Units] )
)

but want to use ADDCOLUMNS, so,

EVALUATE
ADDCOLUMNS ( VALUES ( Table1[Date] ), "A", 1 )

but instead of 1 I would like to add the 'item' column as in summarize, but

EVALUATE
ADDCOLUMNS ( ALL ( Table1[Date] ), "A", Table1[Item])

does not work, if I replace [Item] with [Date] then it does?

Richard.

 

[ExcelToDAX]

What data type is Table1[Item]?

 

[dicken]

What data type is Table1[Item]?

It is a column in table1 called 'item' containing text .

Richard

 

[dicken]

What data type is Table1[Item]?

The result I want is as follows ;

EVALUATE
SELECTCOLUMNS( 
 Table1, 
  "Date", Table1[Date] , 
   "Item", Table1[Item], 
    "Units", Table1[Units] 
    )

But using Addcolumns and so starting with

ADDCOLUMNS( VALUES( Table1[Date] )

Richard
,