Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 OpCount,
(Select SUM(fuprodtime * foperqty + fsetuptime + fmovetime) from tblRouting
where JobNo = tblLabor.jobno and operno <= tblLabor.operno) as CompHrs
FROM tblLabor
converted to power query as following:
Solved! Go to Solution.
"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)=>
Thanks Rocco,
that worked.
"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)=>