Forum Discussion

Frequent Visitor

5 years ago

Solved

CONCATENATEX DISTINCT OR VALUES

hi all,

Verantw. Ceelbaas = CONCATENATEX(

FILTER(

ALL(Dim_Dokplan_Ceel),

Dim_Dokplan_Ceel[index date shift scheepsnaam] = Fact_Dokplan_AET[index date shift scheepsnaam]),

Dim_Dokplan_Ceel[Verantw. Ceelb], ",")

I've just writtten above formula (for to have a new column) to retrieve some names of different persons but sometimes the same name disappears twice.

How can I eliminate these duplicates values?

I've already read to use DISTINCT or VALUES but it does not work.

I've tried the following formulas:

Verantw. Ceelbaas = CONCATENATEX(DISTINCT(

FILTER(

ALL(Dim_Dokplan_Ceel),

Dim_Dokplan_Ceel[index date shift scheepsnaam] = Fact_Dokplan_AET[index date shift scheepsnaam])),

Dim_Dokplan_Ceel[Verantw. Ceelb], ",")

'measure' = CONCATEX ( VALUES (Fact_Table [Verantw. Ceelbaas]), Fact_Table [Verantw. Ceelbaas]))

thanks for your advice

L_B
5 years ago
v-lionel-msft ,

thanks for your reply! However, my data is GDPR-sensitive so it is impossible to share this.

grtz!

4 Replies

L_B
Frequent Visitor
5 years ago
CONCATEX ==> this was ofc a typo... 🙂
v-lionel-msft
Community Support
5 years ago
Hi L_B ,

Please show me your sample data, I can't reproduce your data model.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- L_B
  Frequent Visitor
  5 years ago
  v-lionel-msft ,
  
  thanks for your reply! However, my data is GDPR-sensitive so it is impossible to share this.
  
  grtz!
v-lionel-msft
Community Support
5 years ago
Hi L_B ,

Please show me your sample data, I can't reproduce your data model.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.