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 I have replicated the same steps but for few of the account_nos, it shows a different value.
eg:
The expected output for the highlighted account_no is complete as it has only one value"record_set"
Hi poojithas ,
What is the final desired result you want to present?
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
- poojithas
Anonymous 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