Forum Discussion

sivarajan21's avatar
sivarajan21
Icon for Post Prodigy rankPost Prodigy
3 years ago
Solved

Convert 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...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Arul's avatar
Arul
Icon for Super User rankSuper User
3 years ago

sivarajan21 ,

this is what I have achieved so far, just able to find the missing dates in a new calculated table,

Max date1 = 
VAR _distinctDates = VALUES('Table'[Date])
VAR _maxDate = CALCULATE(
    MAX('Table '[Date]),
    ALLEXCEPT('Table ','Table '[Points]))
VAR _minDate = CALCULATE(
    MIN('Table '[Date]),
    ALLEXCEPT('Table ','Table '[Points]))
VAR _calendar = CALENDAR(
    _minDate,_maxDate)
VAR _compare = EXCEPT(_calendar,_distinctDates)
RETURN _compare

Thanks,

Arul

sivarajan21's avatar
sivarajan21
Icon for Post Prodigy rankPost Prodigy
3 years ago

Hi Arul,

 

Thanks for your response

However for some reason the table generated has missing year 2022.

Also, I couldn't filter this table using points id even if i establish a relationship between these two.

 

Thanks in advance.