Forum Discussion

Frequent Visitor

2 years ago

Solved

Status values for each application ID

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" valu...

Need Help

ryan_mayu
2 years ago
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"))

Anonymous

Not applicable

2 years ago

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: