Combine 10 columns of info (Only show unique Entrys)

[Dclunie]

Hi All

New to power bi, so apologies.


We have data that tracks tasks by departments 1-10. If a department has a task, it will then show within the tables. For reporting, this is not great as I want to be able to filter based on unique entries and if is true or false.

I want a merged column with all departments combined, only showing a value if found and only showing a unique department entry.

Example

OCR031173 shows a task for BOM on Assigne departments 1 and 2.
I would expect to see one entry in the combined column.

Would anybody be willing to help me achieve this?

We use this code in xls

=TEXTJOIN(",",TRUE,UNIQUE(AH2:AQ2,TRUE))

Test merge data.pbix 

[barritown · Accepted solution]

Hi,

I guess you've failed to attach your PBIX file.

I've created a toy table and based on your Excel formula composed such a calculated column:

Hope it helps.