Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- (table,Mt0,Mt1) => let
- #"Add Yt.1" = Table.AddColumn(table, "placeholder",
- each if Table.Column(table,Mt0) <= 0 or - Table.Column(table,Mt1) < Table.Column(table,Mt0)
- then Table.FromRecords({[Mt0 = Table.Column(table,Mt0), Mt1 = Table.Column(table,Mt1)]})
- else Table.FromRecords({[Mt0 = 0,Mt1 = Table.Column(table,Mt1) + Table.Column(table,Mt0)]}))/*,
- #"Expand Yt.1" = Table.ExpandTableColumn(Table.RemoveColumns(#"Add Yt.1",{"Mt0", "Mt1"}), "placeholder", {"Mt0","Mt1"})*/
- in #"Add Yt.1"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement