Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello! I am looking to create a column in my table to create a personalized filter.
I am wanting to create a column that is basically "if this cell contains x, y, and z, print Unit"
This is what I wrote... but it isn't working right now. Just not sure how to create this formula.
Solved! Go to Solution.
I tried that... but it didn't work. My data that I'm pulling from looks like this:
January TMMWV TNGA
So I need to pull if that line has TMMWV, print Unit.
Thanks again!
Try this:
Type of Plant =
SWITCH (
TRUE,
CONTAINSSTRING ( Merge1[Plant and Line], "TMMAL" )
|| CONTAINSSTRING ( Merge1[Plant and Line], "TMMK PWT" )
|| CONTAINSSTRING ( Merge1[Plant and Line], "TMMWV" ), "Unit",
CONTAINSSTRING ( Merge1[Plant and Line], "TMMBC" )
|| CONTAINSSTRING ( Merge1[Plant and Line], "TMMI" )
|| CONTAINSSTRING ( Merge1[Plant and Line], "TMMK" )
|| CONTAINSSTRING ( Merge1[Plant and Line], "TMMC" )
|| CONTAINSSTRING ( Merge1[Plant and Line], "TMMGT" )
|| CONTAINSSTRING ( Merge1[Plant and Line], "TMMTX" ), "Vehicle",
"NEED TO INCLUDE"
)
Proud to be a Super User!
Try this calculated column:
Type of Plant =
SWITCH (
TRUE,
Merge1[Plant and Line] IN { "TMMAL", "TMMK PWT", "TMMWV" }, "Unit",
Merge1[Plant and Line] IN { "TMMBC", "TMMI", "TMMK", "TMMC", "TMMGT", "TMMTX" }, "Vehicle",
"NEED TO INCLUDE"
)
Proud to be a Super User!
I tried that... but it didn't work. My data that I'm pulling from looks like this:
January TMMWV TNGA
So I need to pull if that line has TMMWV, print Unit.
Thanks again!
Try this:
Type of Plant =
SWITCH (
TRUE,
CONTAINSSTRING ( Merge1[Plant and Line], "TMMAL" )
|| CONTAINSSTRING ( Merge1[Plant and Line], "TMMK PWT" )
|| CONTAINSSTRING ( Merge1[Plant and Line], "TMMWV" ), "Unit",
CONTAINSSTRING ( Merge1[Plant and Line], "TMMBC" )
|| CONTAINSSTRING ( Merge1[Plant and Line], "TMMI" )
|| CONTAINSSTRING ( Merge1[Plant and Line], "TMMK" )
|| CONTAINSSTRING ( Merge1[Plant and Line], "TMMC" )
|| CONTAINSSTRING ( Merge1[Plant and Line], "TMMGT" )
|| CONTAINSSTRING ( Merge1[Plant and Line], "TMMTX" ), "Vehicle",
"NEED TO INCLUDE"
)
Proud to be a Super User!
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
104 | |
93 | |
83 | |
64 |