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,
How to use wildcard with In Statment?
Solved! Go to Solution.
@Chandrashekar I dont think so it possible with IN but we have certain other option as well like search or you can create in PQ using conditional column. In case you want to add multiple conditions then you can use below code:-
Column =
IF ( CONTAINSSTRING ( [state], "action" ) || CONTAINSSTRING ( [state], "condition1" ) || CONTAINSSTRING ( [state], "condition2" ), "Action" )
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Please try like below:-
Column =
IF ( CONTAINSSTRING ( [state], "action" ), "Action" )
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Hello Samarth,
Is it possible with In function?
Regards,
Chandrashekar B
@Chandrashekar I dont think so it possible with IN but we have certain other option as well like search or you can create in PQ using conditional column. In case you want to add multiple conditions then you can use below code:-
Column =
IF ( CONTAINSSTRING ( [state], "action" ) || CONTAINSSTRING ( [state], "condition1" ) || CONTAINSSTRING ( [state], "condition2" ), "Action" )
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Thanks Samarth
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
69 | |
36 | |
21 | |
17 | |
15 |
User | Count |
---|---|
126 | |
32 | |
28 | |
24 | |
23 |