Forum Discussion
sivarajan21
Post Prodigy
Post ProdigyConvert Comma separated dax measure into a list
Hi, I have created a measure that gives dates in a comma separated format in a matrix visual(shows issue in below screenshot) But I am confused how to get these dates in a list(one date pe...
grantsamborn
Solution Sage
Solution SageHi sivarajan21
I thought you needed a calculated table instead of a matrix or table visual. My mistake.
I'l be busy for the next 4 hours but will take a look at it later.
Grant
grantsambornSolution Sage
Solution SageHi sivarajan21
I'm sorry I didn't get back to you. I'm drawing a blank here.
Maybe you should ask a few of the Super-Users.
sivarajan21Hi grantsamborn
No problem and thanks for your prompt response😊
Don't know how to contact super users. Any lead could be appreciated
Thanks in advance
- grantsamborn
Maybe one of these can help?
- lbendlin
Super User
A measure can contain table variables but ultimately MUST return a scalar value. You cannot "distribute measure results across rows", instead you need to have a disconnected table with row numbers and then you can calculate the measure output separately for each row.
