Forum Discussion
Solved
Multiple Intermediate step
ImkeF came across this awesome link and I was wondering if there is a way to refer to multiple/any intermediate steps.
E.g.
// dims table
let
dimOne = #table({"ky", "valOne"}, {{"...
Try changing your dims table to this:
let dimOne = #table({"ky", "valOne"}, {{"ky1", 90.3}, {"ky2", 89.5}}), dimTwo = #table({"ky", "valTwo"}, {{"ky1", 1}, {"ky2", 2}}), metaStep = dimTwo meta[ref1=dimOne, ref2=dimTwo] in metaStep
Try changing your dims table to this:
let
dimOne = #table({"ky", "valOne"}, {{"ky1", 90.3}, {"ky2", 89.5}}),
dimTwo = #table({"ky", "valTwo"}, {{"ky1", 1}, {"ky2", 2}}),
metaStep = dimTwo meta[ref1=dimOne, ref2=dimTwo]
in
metaStep
This does not work in service df
Error: Expression.Error: The field 'ref1' of the record wasn't found//DateTbl
let
Source = {2023..2025},
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
------------------------------------------------------------
metaStep = #"Replace errors" meta[ref1=Source, ref2= #"Replace errors"]
in
metaStep
//dimTbl
let
Source = Text.From(Value.Metadata(DateTbl)[ref1]{1}),
#"Convert to table" = Table.FromValue(Source)
in
#"Convert to table"