Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to 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!
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!
click "Add Clause"