• MVP Logo
  • Recent Forum Posts

    Ken Puls

    Power Query Challenge 5

    There's some cool solutions there! I've attached mine, which was focused on readability and maintainability for a new-to-power-query user. (In our workshop...

    Ken Puls Today, 04:57 PM Go to last post
    Nick Burns

    Sum multiple columns in PQ

    Digging up this old thread - is there a way to total only columns that are numeric?

    With this:
    = Table.AddColumn(YourPreviousStep,...

    Nick Burns Today, 04:40 PM Go to last post
    standardF

    Formular Challenge

    Thanks NoS but I can't find a way around this...

    standardF Today, 04:34 PM Go to last post
    NoS

    Formular Challenge

    click or tab into the cell with the formula,
    from the Formulas Ribbon, Formula Auditing section, click Evaluate Formula,
    you can now step...

    NoS Today, 04:10 PM Go to last post
    bdarbonneau

    Power Query Challenge 5

    A more brute-force approach than compared to that of fshaikh, but a solution still....

    bdarbonneau Today, 01:51 PM Go to last post