Hi, thanks for taking an interest.
There were no measures, the "size" field is a numeric field in the combined query.
The only box I haven't ticked is having the latest version (I don't have admin rights and its after hours here).
I made a stripped down version of the app and removed everything except the function, the source queries (the ones I am combining) and the query that consumes the function. I also deleted all relationships and still had the same problem. I then deleted all visuals and the problem remains.
All of the elements are included below (note the source queries are all drawn from seperate excel files...
addFY
Let
export = (baseName as text, fy as list) =>
let
ret = List.Transform(fy, each
let
name = "#" & """" & Text.Replace(baseName, "$", Text.From(_)) & """",
t = Table.Buffer(Expression.Evaluate(name, #shared)),
year = _
in
Table.AddColumn(t, "FY", each year)
)
in
ret
in
export
// Table.Combine(addFY("Invoice_Summary FY to $", {2012,2013,2014,2015,2016,2017}))
There is one of these for each FY, all from different excel files…
Invoice_Summary FY to 20XX
let
Source = Excel.Workbook(File.Contents("C:\Users\...\file with one FY data.xlsx"), null, true),
Invoice_Summary_Table = Source{[Item="Invoice_Summary",Kind="Table"]}[Data]
in
Invoice_Summary_Table
AllInvoices query…
Let
AllYears = Table.Combine(addFY("Invoice_Summary FY to $", {2012,2013,2014,2015,2016,2017}))
in
AllYears
