Forum Discussion

king2005r's avatar
king2005r
Icon for Helper III rankHelper III
4 years ago
Solved

Check the previous column value, with default status

Hi Everyone,    I need your help, I have very sample request   I want the formula to check if there any previous "active" orders for the same customer ID that has "Active" status so the final out...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

     

    All customers package deliver CC =
    IF (
    "Active"
    IN SUMMARIZE (
    FILTER ( Data, Data[Customer ID] = EARLIER ( Data[Customer ID] ) ),
    Data[Status]
    ),
    "Not yet",
    "Yes"
    )

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
4 years ago

 

All customers package deliver CC =
IF (
"Active"
IN SUMMARIZE (
FILTER ( Data, Data[Customer ID] = EARLIER ( Data[Customer ID] ) ),
Data[Status]
),
"Not yet",
"Yes"
)

king2005r's avatar
king2005r
Icon for Helper III rankHelper III
4 years ago

Thank you so much, this is work fine 🙂 appreciated!