Forum Discussion

Ttaylor9870's avatar
Ttaylor9870
Icon for Helper III rankHelper III
3 years ago
Solved

DAX Help to assign a value based on another value

Hi Experts, Hope you're well!!   I need help with this problem I have which should hopefully be easy for you guys,   The Problem as follows...   ID Delivery Day New Delivery Day AAA 5 ...
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi Ttaylor9870 

    you may try to add a calculated column like:

    Column = 
VAR _list = 
CALCULATETABLE(
    VALUES(data[Delivery Day]),
    data[ID] = EARLIER(data[ID]),
    ALLEXCEPT(data, data[ID])
)
RETURN
IF(
    5 IN _list,
    5, 
    MINX(
        FILTER(data, data[ID] = EARLIER(data[ID])),
        data[Delivery Day]
    )
)

    it worked like:

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi Ttaylor9870 

you may try to add a calculated column like:

Column = 
VAR _list = 
CALCULATETABLE(
    VALUES(data[Delivery Day]),
    data[ID] = EARLIER(data[ID]),
    ALLEXCEPT(data, data[ID])
)
RETURN
IF(
    5 IN _list,
    5, 
    MINX(
        FILTER(data, data[ID] = EARLIER(data[ID])),
        data[Delivery Day]
    )
)

it worked like: