creating a new column based on different conditions

Hi, Anonymous 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Table:

You may create a measure or a calculated column as below.

Measure:

Result Measure = 
var _value = SELECTEDVALUE('Table'[Value])
var _previousvalue =
CALCULATE(
    SUM('Table'[Value]),
    FILTER(
        ALL('Table'),
        'Table'[Date] = SELECTEDVALUE('Table'[Date])-1
    )
)
return
SWITCH(
    TRUE(),
    _value<30,"Initial",
    _value>60,"High",
    NOT(ISBLANK(_previousvalue))&&_value>=30&&_value<=60,
    IF(
        _previousvalue<=_value,
        "Low to High",
        "High to Low"
    )
)

Calculated column:

Result Column = 
var _previousvalue =
CALCULATE(
    SUM('Table'[Value]),
    FILTER(
        ALL('Table'),
        'Table'[Date] = EARLIER('Table'[Date])-1
    )
)
return
SWITCH(
    TRUE(),
    [Value]<30,"Initial",
    [Value]>60,"High",
    NOT(ISBLANK(_previousvalue))&&[Value]>=30&&[Value]<=60,
    IF(
        _previousvalue<=[Value],
        "Low to High",
        "High to Low"
    )
)

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.