Forum Discussion
Helper IIICalculated column in Power BI
Hi poojithas ,
As shown below are my calculations of the expected results for each of the three tables you want.
You can refer to my pbix file for better understanding.
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Helper IIIAnonymous If there are duplicate acccount_no, i.e, if one account_no has two values for DQ_Issue (Record_set and Non-Unique) or (Record_Set or Incomplete), then the new column should have the value as "Non-Unique/Unique" or "Incomplete/Complete"
Sample data below
Table 1
| Account_no | DQ_Issue |
Account1 | Record_Set |
| Account2 | Record_Set |
| Account3 | Record_Set |
| Account4 | Record_Set |
Account1 | Non-Unique |
| Account2 | Non-Unique |
| Account3 | Non-Unique |
Expected Output:
| Account_no | New column |
Account1 | Non-Unique |
| Account2 | Non-Unique |
| Account3 | Non-Unique |
| Account4 | Unique |
Table 2
| Account_no | DQ_Issue |
Account1 | Record_Set |
| Account2 | Record_Set |
| Account3 | Record_Set |
| Account4 | Record_Set |
Account1 | Incomplete |
| Account2 | Incomplete |
Expected Output:
| Account_no | New column |
Account1 | Incomplete |
| Account2 | Incomplete |
| Account3 | Complete |
| Account4 | Complete |
Table 3
| Account_no | DQ_Issue |
Account1 | Record_Set |
| Account2 | Record_Set |
| Account3 | Record_Set |
| Account4 | Record_Set |
| Account5 | Record_Set |
Account1 | Record_Set |
| Account3 | Record_Set |
| Account2 | Incomplete |
| Account5 | Incomplete |
Expected Output:
| Account_no | New column |
Account1 | Complete |
| Account2 | Incomplete |
| Account3 | Complete |
| Account4 | Complete |
| Account5 | Incomplete |
Hi poojithas ,
As shown below are my calculations of the expected results for each of the three tables you want.
You can refer to my pbix file for better understanding.
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly