DRSteele
Well-known Member
- Joined
- Mar 31, 2015
- Messages
- 2,640
- Office Version
- 365
- Platform
- Windows
Can someone please help me in Power Query?
I would like a custom column to report the maximum magnitude of values per record, in other words I would like the max absolute values. The column names are on row 30. It seems easy in Excel, but I can't figure out the syntax in PQ.
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
<tbody>
</tbody>
I would like a custom column to report the maximum magnitude of values per record, in other words I would like the max absolute values. The column names are on row 30. It seems easy in Excel, but I can't figure out the syntax in PQ.
A | B | C | D | E | F | G | H | I | |
---|---|---|---|---|---|---|---|---|---|
30 | Forecast Day | 1 | 2 | 3 | 4 | 5 | 6 | 7 | Max Magnitude |
31 | 8/23/2017 | -2.1 | -0.1 | -0.1 | -1.1 | -1.1 | -3.1 | -6.1 | 6.1 |
32 | 8/24/2017 | -1.5 | -1.5 | -3.5 | -2.5 | -2.5 | -4.5 | -0.5 | 4.5 |
33 | 8/25/2017 | -0.2 | -0.2 | -0.2 | -1.2 | -1.2 | -1.2 | -1.2 | 1.2 |
34 | 8/26/2017 | -1.8 | 0.2 | 0.2 | 0.2 | -0.8 | -1.8 | -2.8 | 2.8 |
35 | 8/27/2017 | -2.1 | -1.1 | -2.1 | -1.1 | -1.1 | -3.1 | -5.1 | 5.1 |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Query2
Array Formulas
<thead> </thead><tbody> </tbody> Note: Do not try and enter the {} manually yourself |
<tbody>
</tbody>