Forum Discussion
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 |
| 124 | Fullypaid | Fullypaid |
| 125 | 1 | Non Fullypaid |
| 125 | 2 | Non Fullypaid |
| 125 | 3 | Non Fullypaid |
| 126 | 1 | Fullypaid |
| 126 | 2 | Fullypaid |
| 126 | Fullypaid | Fullypaid |
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" )
5 Replies
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" )Simplest Excel formula is way more than enough to solve such a small question
=IF(COUNTIFS([ID];[@ID];[Status];"Fullypaid");"Fullypaid";"Non Fullypaid")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:
