Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Team,
Please help me in calculating the status based on the supplier id. If Any supplier id is expired then it shouldn't be counted as active status.
I have highlighted few supplier id 102 where it has both status active and expired. If any supplier is expired then it shouldnt't be counted as Active. Then I should get the count for that supplier as expired only.
Moreover If any supplier is having only active status then it should be counted as Active. Every supplier is should have only single status either active or expired. But if any supplier is havign two status then it should be counted as "Expired" only.
Help needed...!
Thanks,
Rob
Solved! Go to Solution.
You may add the following calculated column.
Column = IF ( CONTAINS ( Table1, Table1[Supplier ID], Table1[Supplier ID], Table1[Status], "Expired" ), "Expired", "Active" )
You may add the following calculated column.
Column = IF ( CONTAINS ( Table1, Table1[Supplier ID], Table1[Supplier ID], Table1[Status], "Expired" ), "Expired", "Active" )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |