Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |