Forum Discussion

msalas's avatar
msalas
Regular Visitor
2 years ago
Solved

Help with a formula

Hello,

I need help with a formula, see my formula below. It is giving me an error. What I'm trying to do is, if the "Work Order Age" is between 90 and 1095, then I want a count of 1, else 0. I can't seem to figure out the formula 

 

if [Work Order Age] is > 90 & [Work Order Age] is < 1095
then 1
else 0

 

 

 

Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    Table.AddColumn(PriorStepOrTableName, "Count", each if List.AllTrue({[Work Order Age] > 90, [Work Order Age] < 1095}) then 1 else 0)

     

    --Nate

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Table.AddColumn(PriorStepOrTableName, "Count", each if List.AllTrue({[Work Order Age] > 90, [Work Order Age] < 1095}) then 1 else 0)

     

    --Nate

  • foodd's avatar
    foodd
    Community Champion
    2 years ago
    Work Order Status = IF(AND([Work Order Age] > 90, [Work Order Age] < 1095), 1, 0)