Log In
Register
Home
February 1, 2019
Offline
Hi,
i have table where i have Named ranges names : NR_1, NR_2, NR_3 (as strings):
and now i want to calculate each table field to get results like here:
How can i achive?
Best,
Jacek
See Answer
Trusted Members
February 13, 2021
Offline
I'm confused as to what you are wanting, from your attached file it looks like you just want to return the string of the named ranges in which case you need only reference the named range. I feel like I'm missing something, though?
Trusted Members
Moderators
November 1, 2018
Offline
You could write a separate function for it, or just add a custom column - for example:
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Col1", type text}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Excel.CurrentWorkbook(){[Name=[Col1]]}[Content]{0}),
#"Expanded Custom" = Table.ExpandRecordColumn(#"Added Custom", "Custom", {"Column1"}, {"Column1"})
in
#"Expanded Custom"
Answers Post
1 Guest(s)
