The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.