Help with a formula

[msalas]

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

[Anonymous · Accepted solution]

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

--Nate

[foodd]

Work Order Status = IF(AND([Work Order Age] > 90, [Work Order Age] < 1095), 1, 0)