topic Re: i need help in DAX Commands and Tips

i need help

Anonymous — Sat, 22 Apr 2023 03:04:10 GMT

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

Re: i need help

Jihwan_Kim — Sat, 22 Apr 2023 03:12:38 GMT

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

Re: i need help

ThxAlot — Sat, 22 Apr 2023 05:21:20 GMT

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

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

Re: i need help

Anonymous — Sat, 22 Apr 2023 05:46:07 GMT

Thank you so much Sir

Re: i need help

FreemanZ — Sat, 22 Apr 2023 13:33:00 GMT

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

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

it worked like:

Re: i need help

Anonymous — Thu, 27 Apr 2023 12:03:19 GMT

thank you much, resloved