The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I'm trying to create a column which looks if text in Column A = "" (Which means it is unassigned), and if the deadline date is within 7 days of todays date.
I've tried lots of different things but still seem to be getting an error.
Here is my code below:
=if [Assigned to] = "" or Date.AddDays([Deadline Date], -7) then "High" else "Low"
You need a comparator in your Date.AddDays function. At the moment, you are saying "if assigned to is blank, or (deadline date minus 7) then high, otherwise low". You need to say "if assigned to is blank, or (deadline date minus 7) IS LESS THAN TODAY then high, otherwise low".
Try:
if [Assigned to] = "" or Date.AddDays([Deadline Date], -7) < DateTime.LocalNow() then "High" else "Low"
or:
if [Assigned to] = "" or Duration.Days(DateTime.LocalNow() - [Deadline Date]) < 7 then "High" else "Low"
The syntax may not be exact but I hope you get the idea.