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

     

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
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"
)