Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Frequent Visitor

Formula with Conditions

I hope this is the right place for this, but looking for some help in what I am doing wrong. I want to add a column where it will output if a purchase is Eligible/Not Eligible based on specific criteria within my data table and I keep running into errors. 

Eligibility criteria:
Date falls between Sept 1, 2023 and October 31, 2023
Product ID is 8598
Purchase Country is Canada
Purchase Name is not OP

EligibleColumn = IF(
        'Table 1' [Date] >= DATE(2023,09,01),
        'Table 1 '[Date] <= DATE (2023,10,31),
        'Table 1 '[ID] = "8598",
        'Table 1'[Country] = "Canada",
        NOT('Table 1'[Name] = "OP"),
    "Not Eligible"

Any ideas what I am doing wrong?

Super User
Super User

Hi @NikkiG12 ,


The syntax looks like you used DAX, but you posted this in the Power Query forum, so I believe you actually are interested in a solution in M:



Here the code in M:

if [Date] >= #date(2023,9,1) and
   [Date] <= #date(2023,10,31) and
   [ID] = 8598 and 
   [Country] = "Canada" and
   [Name] <> "OP" then "Eligible" else "Not Eligible"


Let me know if this solves your issue 🙂



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn


Thank you, I'll give this a try

Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors