Can you use SUMMARIZECOLUMNS to create a table like you would in Power BI RRS feed

  • Question

  • Power Query novice here:

    I have a Weather table that sources data from multiple weather stations. What I want is to perform a "Group By" on that Weather table to get a new table that aggregates by Date. 

    I can do this easily in PowerBI by clicking the "New Table" button under the modeling tab and using this code:


    DAX High PRCP by Date = SUMMARIZECOLUMNS('Weather_withZip!'[DATE], "High PRCP Zones", [HighPRCP], "Med PRCP Zones", [MedPRCP], "Low PRCP Zones", [LowPrcp], "Any PRCP Zones", [AnyPRCP])

    I can't figure out if the same thing is possible in Power Query/Excel. There's no "New Table" button, and I can't use this code in a measure in my PowerPivot table.

    My data would be much easier to analyze in Excel so I'm hoping there would be a way to create this aggregate, "Grouped by" table.


    • Edited by elprobst Thursday, August 29, 2019 3:31 PM spelling
    Thursday, August 29, 2019 3:31 PM