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 GUYS and GALS
is it poassable to add a column to a exsting table based on another table using a if statement
i.e
Table one
Ref | Status | blah | blah blah |
1 | A | 1 | 5 |
2 | A | 1 | 5 |
3 | R | 2 | 5 |
Table 2
Ref | Stataus No | status | notes |
1 | 1 | Raised | blah blah blah |
1 | 2 | Dispatched | blah blah blah |
1 | 3 | Dilivered | blah blah blah |
2 | 1 | Raised | blah blah blah |
2 | 2 | Dispatched | blah blah blah |
3 | 99 | Out of stock | blah blah blah |
Combined table
i only want notes when theres a problem (status 99) other wise blank
Ref | Status | blah | blah blah | notes |
1 | G | 1 | 5 | |
2 | A | 1 | 5 | |
3 | 99 | 2 | 5 | blah blah blah |
Solved! Go to Solution.
Simply try LOOKUPVALUE Function.
notes = LOOKUPVALUE ( Table2[notes], Table2[Ref], Table1[Ref], Table2[Stataus No], 99 )
Hi @Sir_night,
Yes, its very much possible. Make sure you related the two tables before writing DAX to create a new column using IF statement.
Prateek Raina
Simply try LOOKUPVALUE Function.
notes = LOOKUPVALUE ( Table2[notes], Table2[Ref], Table1[Ref], Table2[Stataus No], 99 )
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 |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |