Having Trouble in Power Query

[Anonymous]

@ links to members, content

I am new to Power Query.  I tried to add this column  I am getting error message "Token Literal expected".  Here is my DAX in power query 

= Table.AddColumn(#"Changed Type1", "CalDueFormat", each if [Calibration Due] > Date.From(DateTime.LocalNow()) & if [Calibration Due] < Date.From(DateTime.LocalNow()+ 90 then "Due in 90 Days" else if [Calibration Due] > Date.From(DateTime.LocalNow()) then |
"In Calibration" else "OverDue")

My two condition is not being evaluated.  The results only returns "OverDue" 

[mussaenda]

you think you should use "and" instead of "&"?

or you should use "or" instead of "&".

Try to play with these until you get your desired result.

If you need more help,

provide a sample data.

Thanks

[Anonymous]

the issue is the formula is not reading the first condition I do have some rows that meet that first condition.  I am having trouble adding 90 days to the Date.AddDays(DateTime.LocalNow(),90). I am getting error message "Token Literal Expected"

= Table.AddColumn(#"Changed Type1", "CalDueFormat", each if [Calibration Due] > Date.From(DateTime.LocalNow()) and if [Calibration Due] < Date.AddDays(DateTime.LocalNow(),90) then "Due in 90 Days" else if [Calibration Due] > Date.From(DateTime.LocalNow()) then
"In Calibration" else "OverDue")

[Vijay_A_Verma]

Use below formula

= Table.AddColumn(#"Changed Type1", "CalDueFormat", each if [Calibration Due] <= Date.From(DateTime.LocalNow()) then "In Calibration" else if [Calibration Due] <= Date.From(Date.AddDays(DateTime.LocalNow(),90)) then "Due in 90 Days"
else "Overdue")

[Anonymous]

Thank you for adjusting the formula, it is returning the expected text string but applying color coding to wrong columns.  Where it is saying "In Calibration"  it should have "OverDue" and where it is "In Calibration" it should say "OverDue". 

This is my color measure

CalColor = SWITCH(

SELECTEDVALUE('DL - Tools, Test Equipment, and Tech Gear'[CalDueFormat]),

"OverDue", "Red",

"Due in 90 Days", "Yellow",

"In Calibration", "Green"

)

I really appreciate your help on this.  Getting close to the expected solution. 

[Vijay_A_Verma · Accepted solution]

Use this please

= Table.AddColumn(#"Changed Type1", "CalDueFormat", each if [Calibration Due] <= Date.From(DateTime.LocalNow()) then "Overdue" else if [Calibration Due] <= Date.From(Date.AddDays(DateTime.LocalNow(),90)) then "Due in 90 Days"
else "In Calibration")