Forum Discussion

NikkiG12's avatar
NikkiG12
Frequent Visitor
2 years ago

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(
    AND(
        '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"),
  )
    "Eligible",
    "Not Eligible"
)  


Any ideas what I am doing wrong?

Need Help

2 Replies

  • tackytechtom's avatar
    tackytechtom
    Most Valuable Professional
    2 years ago

    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 🙂

     

    /Tom
    https://www.tackytech.blog/
    https://www.instagram.com/tackytechtom/