How to do put AND condition when creating Add Column in Power query ?

[ashmitp869]

Hi All.

How to put and condition in Power query when add column.

I have to put the logic like  if

timesheet_date >= qualification_complete_date and timesheet_date <= qualification_expiry_date:

dict_temp["Qualified"] = "Qualified" 

I tried to use like below - but I need the two and third line with and operation .

Need help

[v-jingzhan-msft · Accepted solution]

Hi @ashmitp869 you can add a custom column with below code

if Text.Contains([Comments], "L") then "Learner" else if [Timesheet Date] >= [Date End Check] and [Timesheet Date] <= [Date Expiry Final] then "Qualified" else "Not Qualified"

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[wdx223_Daniel]

click "Add Clause"