/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

8 votes552 views1 answer
Excel vba make word from bytes
VBA
-1 vote230 views1 answer
Vba code to add new column in table
VBA
1 vote239 views1 answer
Excel vba How to determine if a date falls on the weekend?
VBA
8 votes381 views1 answer
Excel vba determine number of elements in a 1D array
VBA
1 vote226 views1 answer
Vba compile error object required
VBA
25 votes529 views2 answers
Excel vba folder exist
VBA
0 vote227 views1 answer
Get current year vb
VBA
0 vote242 views1 answer
Vba compare strings
VBA
0 vote244 views1 answer
Vba simple quote
VBA
0 vote230 views1 answer
Add text to combobox drop down vb
VBA