Forum Discussion

rdnguyen's avatar
rdnguyen
Icon for Helper V rankHelper V
4 years ago
Solved

Error "We cannot convert a value of type Function to type Logical"

Hi All, I have this SQL query that I tried to convert to Power Query SELECT  labID, (Select COUNT(*) from tblRouting           where JobNo = tblLabor.jobno and operno <= tblLabor.operno) as OpCou...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago
    "Added custom" = Table.AddColumn(#"Merged queries", "Custom", each Table.SelectRows(Table.Buffer([jr]),each (jr)=> jr[operno] <= [operno] )),

     

     

    "Added custom" = Table.AddColumn(#"Merged queries", "Custom", each Table.SelectRows(Table.Buffer([jr]),(jr)=> jr[operno] <= [operno] )),

    try to cut each on front of (jr)=>

rdnguyen's avatar
rdnguyen
Icon for Helper V rankHelper V
4 years ago

Thanks Rocco,

that worked.