Forum Discussion
PowerQuery lookup in same table not working
Hi, I am trying to match a value in same table from a different column but i keep getting an error Here is the formula im trying (trying to look up value in Column ContactLookup = if List...
tried this but still no luck
=List.PositionOf(Date.ToText([Date])&[agentName],#"PP_AgentScheduleDetail (2)"[#"ConcatSick&Hol"])
getting a cyclic ref error