Forum Discussion
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...
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"))
