Concatenatex to return unique values from a column based on filter

[SecretChimpanze]

Hi,

I have the below formula that returns something like this --> cat-cat-dog-mouse

Prod Tde Mth Concat Lvl1 = CONCATENATEX(FILTER(SUMMARIZE(Events,Events[trd_mth_prty_id_evnt_cd],Events[prod_grp_lvl_3_nm],Events[Trade Date (date)]),Events[trd_mth_prty_id_evnt_cd]=EARLIER(Events[trd_mth_prty_id_evnt_cd])),Events[prod_grp_lvl_3_nm],"-",Events[Trade Date (date)],ASC)

What I need is unique values only when it comes to the concatenation. So something like this --> cat-dog-mouse.

Hoping there is a way!

[SecretChimpanze]

The error was due to _tab2 where there was a blank space in between the commas var _tab2 = summarize(_tab, ,Events

I fixed it but unfortunately it didn't work - I am still getting duplicate values

[amitchandak]

@SecretChimpanze , Try

Prod Tde Mth Concat Lvl1 =
var _tab = FILTER(SUMMARIZE(Events,Events[trd_mth_prty_id_evnt_cd],Events[prod_grp_lvl_3_nm],Events[Trade Date (date)]),Events[trd_mth_prty_id_evnt_cd]=EARLIER(Events[trd_mth_prty_id_evnt_cd]))
var _tab2 = summarize(_tab, ,Events[prod_grp_lvl_3_nm],Events[Trade Date (date)])
return
CONCATENATEX(_tab2,Events[prod_grp_lvl_3_nm],"-",Events[Trade Date (date)],ASC)