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 crite...
Need Help
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/

NikkiG12's avatar
NikkiG12
Frequent Visitor
2 years ago

Thank you, I'll give this a try