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,
I am trying to change or input a value based on the filtered result and then look at all the rows.
For example:
As you can see below, ID 1 and item 10 may have different possible CONCAT2 values and the trasnformed value of X Y Z, if the result in the CHECK = TRUE, then I want all the lines since they are ID: 1 and ITEM: 10, the desired result for all rows to be "GOOD"
If you see ID: 3 and Item 10, it has both the CHECK as False, so I want all the lines in the desired result to show up as "NOT GOOD" for those 2 rows with ID 3 and Item 10.
ID | ID ITEM | CONCAT 2 | CONCAT3 | CHECK | Desired Result |
1 | 10 | A | X | FALSE | GOOD |
1 | 10 | B | Y | FALSE | GOOD |
1 | 10 | C | Z | TRUE | GOOD |
2 | 10 | D | X | FALSE | GOOD |
2 | 10 | E | Z | TRUE | GOOD |
3 | 10 | F | X | FALSE | NOT GOOD |
3 | 10 | G | Y | FALSE | NOT GOOD |
I am trying to find out how I can do this in PowerBI, any suggestions?
Solved! Go to Solution.
Hi @asunkavalli ,
Sample for your reference.
RESULT = VAR result = CONTAINS ( FILTER ( Table1, Table1[ID] = EARLIER ( Table1[ID] ) && Table1[ID ITEM] = EARLIER ( Table1[ID ITEM] ) ), Table1[CHECK], TRUE () ) RETURN IF ( result = TRUE (), "GOOD", "NOT GOOD" )
Hi @asunkavalli ,
Sample for your reference.
RESULT = VAR result = CONTAINS ( FILTER ( Table1, Table1[ID] = EARLIER ( Table1[ID] ) && Table1[ID ITEM] = EARLIER ( Table1[ID ITEM] ) ), Table1[CHECK], TRUE () ) RETURN IF ( result = TRUE (), "GOOD", "NOT GOOD" )
WOW you are a genius sir! Thank you! I really appreciate your help! It worked magically.
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 |
---|---|
108 | |
98 | |
81 | |
65 | |
62 |
User | Count |
---|---|
147 | |
116 | |
104 | |
88 | |
65 |