---
title: "Discussion on \"Power Query's Missing IN Operator\" | Hashnode"
description: "Discussion on \"Power Query's Missing IN Operator\". Replicate the IN Operator using List.Contains function in M Code"
url: "https://hashnode.com/posts/power-querys-missing-in-operator/656d5b11292b3e7d5327dd12"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Power Query's Missing IN Operator](https://thenavigatedata.com/blog/power-querys-missing-in-operator?utm_source=hashnode&utm_medium=feed)

Replicate the IN Operator using List.Contains function in M Code

Dec 4, 2023 · 3 min read · thenavigatedata.com  
Updated May 24, 2024  
Read the article

-   [#dataflowgen2](https://hashnode.com/tag/dataflowgen2)
-   [#powerbi](https://hashnode.com/tag/powerbi)
-   [#powerquery](https://hashnode.com/tag/powerquery)
-   [#microsoftfabric](https://hashnode.com/tag/microsoftfabric)
-   [#excel](https://hashnode.com/tag/excel)

## Written by

[Parth Lad](https://hashnode.com/@parthlad)

@parthlad · Toronto, Ontario

  
[View profile](https://hashnode.com/@parthlad)

Data Management Analyst

I'm a data analyst who loves finding insights from numbers and visualizing them. I write about Data Analytics, Data Engineering, Power BI, and DAX on Medium & Hashnode. Follow me for more!✌️😉

## Responses

Markdown supported · ⌘↵ to post

No responses yet.