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
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?
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"
thank you working!
Jacek
