Status values for each application ID

[Mond_Ed07]

Hi Fabric Community, its me again asking for help and Im fairly new to using Power BI.

I have columns named NewValue and Application ID

If the NewValue column has "DENIED" or "LOAN PAID OUT" values, I need a new column that says "DENIED" or "LOAN PAID OUT" for that certain Application ID.

I want the result to be like this one but I still don't have the knowledge to do so. 

Any input is very much appreciated. 

Thanks Fabric Community.

[Anonymous]

Hi @Mond_Ed07 

Please try this:

Here I create a set of sample:

Then add a measure:

MEASURE =
VAR _vtable =
    FILTER (
        ALLSELECTED ( 'Table' ),
        'Table'[NewValue] IN { "LOAN PAID OUT", "DENIED" }
    )
RETURN
    CONCATENATEX (
        FILTER ( _vtable, [Application ID] = SELECTEDVALUE ( 'Table'[Application ID] ) ),
        [NewValue]
    )

 The result is as follow:

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Mond_Ed07]

Thanks for the help. I really appreciate it.

[ryan_mayu · Accepted solution]

@Mond_Ed07 

Pls try this to create a column

Column =

VAR _LPO=MAXX(FILTER('Table','Table'[Application ID]=EARLIER('Table'[Application ID])&&'Table'[NewValue]="LOAN PAID OUT"),'Table'[NewValue])

VAR _d=MAXX(FILTER('Table','Table'[Application ID]=EARLIER('Table'[Application ID])&&'Table'[NewValue]="DENIED"),'Table'[NewValue])

return if(_LPO<>"","LOAN PAID OUT", if(_d<>"","DENIED"))

[Mond_Ed07]

Thanks! This is super helpful. I accepted this as a solution.

[ryan_mayu]

you are welcome