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.
I have a filter that includes the line 'Loneliness All Data'[VARIABLE] == "Parliamentary Constituency". I also want this filter to include "LGD" i.e, if the variable column is equal to Parliamentary Constituency or LGD. How do I add in the LGD? I'm sure this must be easy but I'm a newbie and can't figure it out at all!
Here is my code:
Solved! Go to Solution.
Hi @andytmcc,
You can use it like this && 'Loneliness All Data'[VARIABLE] IN {"Parliamentary Constituency", "LGD"}
@ReneMoawad How would I put this same filter requirement FILTER('Loneliness All Data'[VARIABLE] IN {"Parliamentary Constituency", "LGD"} into this code:
Thanks!
Sorry, i didn't mean how would I use the || in that. I meant how would I put this filter FILTER('Loneliness All Data'[VARIABLE] IN {"Parliamentary Constituency", "LGD"} into this code below:
Thank you so much!
Hi @ReneMoawad ,
That's fantastic - thank you so much! I had been trying to use OR but couldn't figure it out. First time coming across IN for me!
Also instead of OR you can use double vertical bar ||
Hi @andytmcc,
You can use it like this && 'Loneliness All Data'[VARIABLE] IN {"Parliamentary Constituency", "LGD"}
User | Count |
---|---|
77 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
100 | |
91 | |
83 | |
61 |