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.

onurbmiguel_'s avatar
onurbmiguel_
Icon for Power Participant rankPower Participant
3 years ago

Hi sivarajan21 

 

Do you have a calendar table? 

 

Why do not use the date in the Rows? 

 

If you need more help please share a pbix with some dummy values.

 

 

Best regards

Bruno Costa | Impactful Individual

 

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍

You can also check out BI4ALL's website and our data solutions!

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

    Hi,

    onurbmiguel_ 

     

    Thanks for your response

    Here I wanted to find the missing dates between 2 columns and I have given a detailed description above.

    Yes I will provide a pbix file but before that please read my description given above. Hope that will give you more information.

     

    please let me know if you need further info

    Thanks in advance.