Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Filter CONCATENATEX command that every value just appears one time

Hi people,     I have the following command:     CONCATENATEX(FILTER('BaseData','BaseData'[OrderNumber]=EARLIER('BaseData'[OrderNumber])),'BaseData'[Team]," ")     Which shows of this resu...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi amitchandak 

 

here is a data sample: sample.pbix  

 

Thanks for the help!