Creating a new column based on multiple, duplicate entries in other columns.

Question

Hi PBI Community,I have 3 tables Tab1, Tab2 and Tab3 with multiple columns and status for each ID.&nbsp; I have joined the 3 tables and currently my final table looks like below. These Ids goes to different status on the same date or different date until it Passes or Fails. I want an output as shown below so that the most current status of a particular Id can be identified on a particular day and unique count of ids can be calculated as per the final status on that day.Please help me how can I create the OUTPUT column. If there a better way to get the solution please recommend that too. Thanks in advance!IDStatus in Tab2 and Tab3Tab NameMap Status in Tab1OUTPUT1InputTab1ExceptionTab1,Tab2,Tab32FailTab3&nbsp;Tab2,Tab31EditTab2ExceptionTab1,Tab2,Tab33PassTab2&nbsp;Tab1,Tab25FailTab3&nbsp;Tab1,Tab31PassTab3&nbsp;Tab1,Tab2,Tab32InputTab2&nbsp;Tab2,Tab33InputTab1ExceptionTab1,Tab25InputTab1CompleteTab1,Tab3

ahmedx · Accepted Answer

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.https://1drv.ms/u/s!AiUZ0Ws7G26Rh3SUEpkzv-Kj15El?e=89XLXJ

Forum Discussion

Creating a new column based on multiple, duplicate entries in other columns.

1 Reply

Related content

Working with copy job and creating duplicates

Create table to remove duplicates

Duplicate ranking

Creating Relationships with duplicative values

Creating multiple Audiences in PowerBI App

ID	Status in Tab2 and Tab3	Tab Name	Map Status in Tab1	OUTPUT
1	Input	Tab1	Exception	Tab1,Tab2,Tab3
2	Fail	Tab3		Tab2,Tab3
1	Edit	Tab2	Exception	Tab1,Tab2,Tab3
3	Pass	Tab2		Tab1,Tab2
5	Fail	Tab3		Tab1,Tab3
1	Pass	Tab3		Tab1,Tab2,Tab3
2	Input	Tab2		Tab2,Tab3
3	Input	Tab1	Exception	Tab1,Tab2
5	Input	Tab1	Complete	Tab1,Tab3