convert multiple rows into single row

Hi Anonymous 

If I understand correctly, by adding a calculated column like below it could be used in columns of a matrix.

Visit No = 
    COUNTROWS(
        FILTER(
            ALL( 'Visits' ),
            'Visits'[ID] = EARLIER( 'Visits'[ID] )
                && 'Visits'[Visit_Date] <= EARLIER( 'Visits'[Visit_Date] )
        )
    )

Visit No.pbix

Let me know if this doesn't help.

Anonymous 

You can add a calculated column with DAX :

Visit_rank = "Visit_"&RANKX(FILTER('Table','Table'[ID ]=EARLIER('Table'[ID ])),'Table'[ Visit_Date],,ASC)

and use this column in the matrix

Pbix is attached.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

 

Hi Anonymous ,

Could you please tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please feel free to let me know.

Best regards,
Community Support Team_Binbin Yu