IF STATEMENT MULTIPLE CONDITIONS

Hi Anonymous 

For the second condition, 

if End date Project of last project differs one day of previous project.

However, in your provided example (result 1456 in New Hours column), 

the condition should be "Start date Project of last project differs one day of End date Project  of previous project"

Start date Project of last project=2019/1/21

End date Project  of previous project=2019/1/20

 

If i misunderstand you, please let me know.

 

Best Regards
Maggie

 

 

 

Hi Anonymous 

Create a new column

previous value =
CALCULATE (
    SUM ( Table1[hours] ),
    FILTER (
        ALLEXCEPT ( Table1, Table1[emp id], Table1[customer id] ),
        Table1[end date project]
            = EARLIER ( Table1[start date project] ) - 1
            && Table1[reason] = "agreement"
    )
)

final result = [hours]+[previous value]

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.