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

     

     

ThxAlot's avatar
ThxAlot
Super User
3 years ago

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

 

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