Forum Discussion
How to avoid duplicate values when using ConcatenateX
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
The above suggestion cannot unfortunately be used in this case.
The item is a kind of key (which is not unique at Table1 but is unique at Table2).
The item is found in Table 1 several times with a different value of YYYY-MM.
In Table2 which has only the distinct values of the items, for each item I would like to have in an column a summary of all YYYY-MM values that are present at the various entries of that item in Table1.
Please note that the YYYY-MM values are handled as text in both tables.
That's why I am using the expression: Table1[Item] = Table2[Item]
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], ", " )