irishbread
New member
- Joined
- Aug 14, 2015
- Messages
- 3
- Reaction score
- 0
- Points
- 0
I have named a cell in Excel 2010 "CurSelect" (derived from the selection made in a dropdown form control) - currently, the only two options from the dropdown are "Par Value" and "Market Value"
When refreshing the table, the "Value" column (see formula below) always returns [MktVal] field data, regardless of whether "Par Value" or "Market Value" is selected from the dropdown. What am I missing?
Thanks.
= Table.AddColumn(#"Changed Type", "Value", each if fnGetValue = "Par Value" then [ParVal] else [MktVal])
let fnGetValue=(CurSelect) =>
let
name = Excel.CurrentWorkbook(){[Name=CurSelect]}[Content],
value = name{0}[Column1]
in
value
in
fnGetValue
When refreshing the table, the "Value" column (see formula below) always returns [MktVal] field data, regardless of whether "Par Value" or "Market Value" is selected from the dropdown. What am I missing?
Thanks.
= Table.AddColumn(#"Changed Type", "Value", each if fnGetValue = "Par Value" then [ParVal] else [MktVal])
let fnGetValue=(CurSelect) =>
let
name = Excel.CurrentWorkbook(){[Name=CurSelect]}[Content],
value = name{0}[Column1]
in
value
in
fnGetValue