/VBA/Power query M substract minimum value of column -dax

Power query M substract minimum value of column -dax

let
    Source = YourTable,
    MinDuration = List.Min(Source[DurationColumn]),
    AddColumn = Table.AddColumn(Source, "SomeNewName", each [Duration] - MinDuration)
in
    AddColumn

Source: social.technet.microsoft.com

Similar codes

1 vote163 views1 answer
Add rows to datagridview vb.net
VBA
0 vote151 views2 answers
Delete all controls from list of control vb.net
VBA
1 vote156 views1 answer
Excel how to format bytes as KB, MB, GB
VBA
0 vote154 views1 answer
Excel R1C1 mode
VBA
3 votes149 views1 answer
Extract the nth word from a text string
VBA
0 vote111 views1 answer
Vba set vs dim
VBA
0 vote200 views1 answer
Excel vba protect content
VBA
8 votes238 views1 answer
Excel vba determine number of elements in a 1D array
VBA
5 votes169 views1 answer
Excel vba tool to help with refactoring code
VBA
5 votes96 views1 answer
Vlookup vba
VBA