Forum Discussion
DAX HELP?
Measure = CONCATENATEX ( VALUES ( Data[Place Name (standardized)]), Data[Place Name (standardized)], ", " )
looks like I got it - validating as we speak, but I think that calculated measure gives me what I want -
Thanks!!
Ha, glad you found it! I was just coming back to post something similar to create the table:
New Table = SUMMARIZE(
TableName,
TableName[Date],
"Category List", CONCATENATEX(TableName, TableName[Category], ", "),
"Sum Minutes", SUM(TableName[Minutes])
)
Date Category Minutes
7/2/2016 Gym 2
7/1/2016 Lobby 2
7/1/2016 Bar 1
7/3/2016 Restaurant 3
7/2/2016 Front Desk 2
7/2/2016 Lobby 10
Sorry, that is the table that I'm trying to use DAX to derive:
Date Category Minutes
7/1/2016 Lobby, Bar 3
7/2/2016 Gym, Front Desk, Lobby 14
7/3/2016 Restaurant 3
Sorry KGrice - this is what the desired output is!
Measure = CONCATENATEX ( VALUES ( Data[Place Name (standardized)]), Data[Place Name (standardized)], ", " )
looks like I got it - validating as we speak, but I think that calculated measure gives me what I want -
Thanks!!
Ha, glad you found it! I was just coming back to post something similar to create the table:
New Table = SUMMARIZE(
TableName,
TableName[Date],
"Category List", CONCATENATEX(TableName, TableName[Category], ", "),
"Sum Minutes", SUM(TableName[Minutes])
)