• MVP Logo
  • Recent Forum Posts

    Pecoflyer

    Sum only numeric columns with PQ

    @Nick


    Please do not hijack existing threads but rather create a new one with eventually a link to any threads of interest. Older threads...

    Pecoflyer Today, 07:28 AM Go to last post
    Kolyu

    Power Query Challenge 5

    The way you replaced null values using = Table.ReplaceValue(Source,null,each _[From],Replacer.ReplaceValue,{"To"}) was interesting
    ...

    Kolyu Today, 07:06 AM Go to last post
    Tobriand

    Cube formulae

    So cube functions are horrible, and thankfully it's been a while since I used them. That said, I think there are two issues you're running into:
    ...

    Tobriand Yesterday, 11:59 PM Go to last post
    Bill Szysz

    Sum only numeric columns with PQ

    No problem, Nick :-))
    = Table.AddColumn(YourPreviousStep, "Sum", each List.Sum(List.Transform(Record.ToList(_), each if _ is number then...

    Bill Szysz Yesterday, 09:52 PM Go to last post
    Nick_M

    Power Query Challenge 5

    My solution
    ...

    Nick_M Yesterday, 08:46 PM Go to last post