Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Having Trouble in Power Query

@ 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...
Show and Tell
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    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")

     

mussaenda's avatar
mussaenda
Community Champion
4 years ago

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