Forum Discussion

smpa01's avatar
smpa01
Community Champion
2 years ago
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"}, {{"...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    2 years ago

    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
AlexisOlson's avatar
AlexisOlson
Super User
2 years ago

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
  • smpa01's avatar
    smpa01
    Community Champion
    2 years ago

    AlexisOlson This is smooth and elegant !!!

  • smpa01's avatar
    smpa01
    Community Champion
    2 years ago

    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"