Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi All, I have date like below, I need to convert multiple rows into single row by ID
ID Visit_Date
101 01/10/2023
101 01/15/2023
101 01/23/2023
102 01/18/2023
102 02/23/2023
I need data as
ID Visit_Date1 Visit_Date2 Visit_Date3
101 01/10/2023 01/15/2023 01/23/2023
102 01/18/2023 02/23/2023
Please help me how to summarize using DAX.
Solved! Go to Solution.
Hi @titanic123
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] )
)
)
Let me know if this doesn't help.
You can add a calculated column with DAX :
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 @titanic123 ,
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
Thanks a lot for the quick response, Both worked correctly.
Hi @titanic123 ,
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
You can add a calculated column with DAX :
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 @titanic123
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] )
)
)
Let me know if this doesn't help.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
76 | |
55 | |
36 | |
34 |
User | Count |
---|---|
99 | |
56 | |
53 | |
44 | |
40 |