i need help

[Anonymous]

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
124	Fullypaid	Fullypaid
125	1	Non Fullypaid
125	2	Non Fullypaid
125	3	Non Fullypaid
126	1	Fullypaid
126	2	Fullypaid
126	Fullypaid	Fullypaid

[Anonymous]

thank you much, resloved

[FreemanZ]

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:

[Anonymous]

Thank you so much Sir

[ThxAlot]

Simplest Excel formula is way more than enough to solve such a small question

=IF(COUNTIFS([ID];[@ID];[Status];"Fullypaid");"Fullypaid";"Non Fullypaid")

[Jihwan_Kim · Accepted solution]

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"
)