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])
ryan_mayuSuper User5 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])
unnijoyPost Prodigy to ryan_mayu5 years agohi ryan_mayu thanks a Lot. its working.ryan_mayuSuper User to unnijoy5 years agoyou are welcome
Related contentLookup helpLookup between two datesLookup function?Dynamic filter using lookupsPower Query LookUp in another table
