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.
Hello
I have three table
ProdCategories
CatID | Name | Status |
AV1 | A | - |
AV2 | B | - |
AV3 | C | X |
AV4 | D | X |
AV5 | E | - |
ProdInventory
ItemID | Item | CatID |
1 | AB | AV1 |
2 | AC | AV1 |
3 | AD | AV2 |
4 | AE | AV4 |
5 | AF | AV3 |
ProdRelease
ItemID | Item | CatID |
2 | AC | AV1 |
4 | AE | AV4 |
6 | DC | AV5 |
7 | TU | AV5 |
ProdInventory and ProdRelease are not related, but both are connected to the ProdCategories by CatID
I want to add a column in the table ProdInventory that checks IF the ProdCategories Status = "X" If
Yes Does a Vlookup In table ProdRelease By ItemID IF find it shows"No" if not shows"Yes"
No shows "No"
Formula from Spreadsheet
=IF(G4="X", IF(ISERROR(VLOOKUP(K4, ProductionInventoryRelease!H: H,1, FALSE)), "No", "YES"), "No")
The result is:
ItemID | Item | CatID | NewColumn |
1 | AB | AV1 | No |
2 | AC | AV1 | No |
3 | AD | AV2 | No |
4 | AE | AV4 | No |
5 | AF | AV3 | Yes |
Thanks in Advance
Solved! Go to Solution.
Hi @ofeliajesus ,
Please try this:
x = IF(RELATED(ProdCategories[Status])="X", If(ISBLANK(LOOKUPVALUE(ProdRelease[Item],ProdRelease[Item],ProdInventory[Item])),"Yes","No"),"No")
You said that you wanted to add a column to your table. Here is what it will look like after creating a calculated column.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Proud to be a Super User!
Hi @ofeliajesus ,
Please try this:
x = IF(RELATED(ProdCategories[Status])="X", If(ISBLANK(LOOKUPVALUE(ProdRelease[Item],ProdRelease[Item],ProdInventory[Item])),"Yes","No"),"No")
You said that you wanted to add a column to your table. Here is what it will look like after creating a calculated column.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Proud to be a Super User!
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.