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 all,
Now I have one pactice with multi IF with following condition, have any one can help me how to solve it. Thanks
Fruits | Valueable | Results |
APPLE | MER | PAK |
ORANGE | TCaccTC | TSS |
APPLE | TCacc | PAK |
ORANGE | AccMER | TSS |
ORANGE | MERACC | TSS |
ORANGE | MER | LINKED |
ORANGE | ACC | TSS |
As above table, if first column "Fruits" encounter "APPLE" then in the result column need show "PAK" and at the meantime at second column "Valueable" has keyword of "acc" or "ACC" then in the "result" column need to show "TSS" otherwise need to show "LINKED". I have no idea how to deal with this multi-column with keyword. Please help me on this. Thanks!
Solved! Go to Solution.
Hi,
Try this calculated column formula
Results = IF([Fruits] = "APPLE","PAK",IF(SEARCH("acc",[Fruits],,0)>0,"TSS","LINKED"))
Hope this helps.
Hi @JimmyKe ,
Results Column =
SWITCH(TRUE(),
[Fruits] = "APPLE","PAK",
SEARCH("acc",[Valueable],,0)<>BLANK(),"TSS",
"LINKED"
)
Pbix as attached.
Hi,
Try this calculated column formula
Results = IF([Fruits] = "APPLE","PAK",IF(SEARCH("acc",[Fruits],,0)>0,"TSS","LINKED"))
Hope this helps.
Use Switch and upper and lower function to deal with case
Switch( TRUE(),
Table[fruits]="APPLE", "PAK",
search("ACC",upper(Table[Valueable]),,0) >0 ,"TSS",
"LINKED"
)
Seems like a SWITCH(TRUE()..) statement to me:
Results Column =
SWITCH(TRUE(),
[Fruits] = "APPLE","PAK",
SEARCH("acc",[Fruits],,0),"TSS",
"LINKED"
)
It's always amazing to me how many data problems deal with fruits... There must be this huge industry ecosystem of people that deal in fruit data that I have never worked with... Especially Apples and Oranges, it's uncanny much data revolves around those two fruits...
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 |
---|---|
110 | |
96 | |
76 | |
63 | |
55 |
User | Count |
---|---|
142 | |
107 | |
89 | |
84 | |
65 |