Forum Discussion
Post ProdigyConvert Comma separated dax measure into a list
Super UserHi,
You can get multiple rows in the same cell. In the CONCATENATEX() function, replace the "," with UNICHAR(10)
sivarajan21Hi Ashish,
Apologise for the delay. I was working on this and testing it.
Brilliant! exactly the solution what I was looking for.
I couldn't imagine it was so easy. currently these dates are in virtual format(result of measure-scalar):
Just to confirm, is it possible to get these missing dates in a summarize kind of table. so that I can use missing dates in a different measure.
Thanks in advance.
Just to confirm, is it possible to create a summarize kind of table in order to use
- Ashish_Mathur
Thank you. I am not clear about your question. Share some data and show the expected result.
- sivarajan21
Hi Ashish,
Apologise for not making it clear!
Below is my example dataset
Data(Date) Points Id Data Date Source 123 04/01/2022 Invoice 123 04/02/2022 Profile 123 04/07/2022 Invoice 123 04/08/2022 Profile 123 04/09/2022 Profile 123 04/10/2022 Profile 123 04/11/2022 Profile Calendar date Date 01/04/2022 02/04/2022 03/04/2022 04/04/2022 05/04/2022 06/04/2022 The above 2 tables are to be compared. What we need to find is the missing calendar dates of points id(data table). That is, the points id '123' in Data table has missing dates 03rd april 2022 that is present in calendar table. so we need to return that missing date in a table format/summarised table.
Expected outcome
Points Id Missing Calendar date 123 03/04/2022 123 04/04/2022 123 05/04/2022 123 06/04/2022 Please let me know if you need further info
Thanks in advance