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...
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

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