unnijoyPost Prodigy5 years agoSolvedLookup i have 2 tables. one is Active HC and other is Inactive HC. In Inactive HC i don't have L2 name. but it is available on Active HC table. i need to find it based on the below logic. Logi...Show Moreryan_mayu5 years agounnijoy pls try this L2 = MAXX(FILTER(ALL(Active),Active[Report Name]=EDATE(Inactive[Report Name],-1)&&Active[OP/CL]="Opening"&&Active[EMPID]=Inactive[EMPID]),Active[L2])
ryan_mayu5 years agounnijoy pls try this L2 = MAXX(FILTER(ALL(Active),Active[Report Name]=EDATE(Inactive[Report Name],-1)&&Active[OP/CL]="Opening"&&Active[EMPID]=Inactive[EMPID]),Active[L2])
ryan_mayu5 years agounnijoy pls try this L2 = MAXX(FILTER(ALL(Active),Active[Report Name]=EDATE(Inactive[Report Name],-1)&&Active[OP/CL]="Opening"&&Active[EMPID]=Inactive[EMPID]),Active[L2])
Related contentLookup helpLookup between two datesLookup function?Dynamic filter using lookupsImporting a Lookup Field
