Forum Discussion
CONCATENATEX unique value
Hi I have a two tables are Data and Report, both tables contain the same headers are “Item” and “Comments”. DATA In data table the item columns contains prefix only and the same item cont...
I created helper column for item in report table (Keep only prefix-item1) and I apply the following calulated column
CONCATENATEX(FILTER(ALL(DATA),DATA[ITEM]=EARLIER(REPORT[ITEM1])),DATA[COMMENTS]),"||") but it will bring it duplicated comments.
I would like to achieve my desired result without duplication columns.
Any advise please.