Forum Discussion

Mond_Ed07's avatar
Mond_Ed07
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" 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.

 

Need Help
  • ryan_mayu's avatar
    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"))
     

5 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    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's avatar
    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:

    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's avatar
      Mond_Ed07
      Frequent Visitor
      2 years ago

      Thanks for the help. I really appreciate it.