The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I am trying to get these two rows into one row by moving the comments based on the date/time stamp.
Example see below current vs. expected
Current | Expected | ||||
Ticket Number | Date | Comments | Ticket Number | Comments | |
500282261 | 10/13/2023 2:01PM | Test123 | 500282261 | Test123--Test456 | |
500282261 | 10/13/2023 2:05PM | Test456 |
Solved! Go to Solution.
Hi @jcastr02 ,
I create a table as you mentioned.
I create a new table and here is the DAX code.
Merged Comments =
SUMMARIZE(
'Table',
'Table'[Ticket Number],
"Comments", CONCATENATEX(
FILTER(
'Table',
'Table'[Ticket Number] = EARLIER('Table'[Ticket Number])
),
'Table'[Comments],
"--"
)
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @jcastr02 ,
I create a table as you mentioned.
I create a new table and here is the DAX code.
Merged Comments =
SUMMARIZE(
'Table',
'Table'[Ticket Number],
"Comments", CONCATENATEX(
FILTER(
'Table',
'Table'[Ticket Number] = EARLIER('Table'[Ticket Number])
),
'Table'[Comments],
"--"
)
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
This M code works
let
Source = Excel.CurrentWorkbook(){[Name="Data"]}[Content],
#"Grouped Rows" = Table.Group(Source, {"Ticket Number"}, {{"All comments", each Text.Combine([Comments],", "), type nullable text}})
in
#"Grouped Rows"
Hope this helps.
User | Count |
---|---|
80 | |
74 | |
41 | |
30 | |
28 |
User | Count |
---|---|
108 | |
96 | |
53 | |
48 | |
47 |