programsam
Board Regular
- Joined
- Feb 10, 2016
- Messages
- 123
I'm attempting to have Power Query parse a list of columns and if the column has a month name as a header, I'd like to have it multiply the values in that column by 1.1 (10% increase). Here's my best attempt but it's giving me an error.
Excel Formula:
= Table.ReplaceValue(#"Renamed Columns", each try Value.Is(Date.From(_), type date), each (_) * 1.1, Replacer.ReplaceValue, {_})