Forum Discussion
Merge in PowerQuery using filters and nearest values.
Hello I have an issue, which to abstract looks a bit like this: Table 1: Inventory ID Item Value 1 TV £30 2 TV £40 3 TV £90 4 Radio £5 5 Radio £10 Table...
=let a=Table.Group(InsuranceProduct,"ProdType",{"n",each Table.Sort(_,"MaxValue")}) in Table.AddColumn(Inventory,"InsuranceName",each let b=a{[ProdType=[Item]]}?[n]? in if b=null then null else Table.Skip(b,(x)=>x[MaxValue]<[Value]){0}?[Name]?)
This seems to throw a cyclic reference error?