Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

i need help

i want below result. ID Status Result 123 Fullypaid Fullypaid 123 1 Fullypaid 123 2 Fullypaid 123 3 Fullypaid 124 Fullypaid Fullypaid 124 Fullypaid Fullypaid 12...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    Please check the below picture and the attached pbix file.

    It is for creating a calculated column.

     

    Result CC =
IF (
    { "Fullypaid" }
        IN SUMMARIZE ( FILTER ( Data, Data[ID] = EARLIER ( Data[ID] ) ), Data[Status] ),
    "Fullypaid",
    "NON"
)

     

     

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

hi Anonymous 

you may also try like:

 

Column = 
VAR _list = 
    CALCULATETABLE(
        VALUES(data[Status]),
        ALLEXCEPT(data, data[ID])
    )
RETURN
IF(
    "Fullypaid" IN _list,
    "Fullypaid",
    "Not Fullypaid"
)

or 

Column2 = 
VAR _list = 
    CALCULATETABLE(
        VALUES(data[Status]),
        data[ID]=EARLIER(data[ID])
    )
RETURN
IF(
    "Fullypaid" IN _list,
    "Fullypaid",
    "Not Fullypaid"
)

 

it worked like: