Forum Discussion
Solved
How to avoid duplicate values when using ConcatenateX
Hi, I am using the below method: AllDates = CONCATENATEX ( FILTER ( ALL ( Table1 ), Table1[Item] = Table2[Item] ), Table1[YYYY-MM], " , " ) and in some cases I get as resul...
It would be easier to tackle your case having a mocking example of your dataset.
Please check the attached file - maybe it is what you need.
Best Regards,
Alexander
It would be easier to tackle your case having a mocking example of your dataset.
Please check the attached file - maybe it is what you need.
Best Regards,
Alexander
Hi,
This did deliver the wanted result, thank you a lot for your help!
I am also providing below the suggested formula of the solution:
YYYY-MM =
VAR curItem = [Item]
RETURN CONCATENATEX ( CALCULATETABLE ( VALUES ( Table1[YYYY-MM] ), Table1[Item] = curItem ), [YYYY-MM], ", " )