I have a data table that I want to summarize. It’s organized by date, ID, and then tons of KPI columns. I have a date reference table that maps each date to a custom fiscal period.
I want to summarize the data table by fiscal period. It’s no problem to do this with SUMMARIZE(), but I have to specify each column.
Is there a way to do this where I can just include all columns from the table being summarized? Listing all of them would be impractical in my case. Seems like this would be a simple thing to do, but I can’t find anyone else asking about the same thing.
question from:https://stackoverflow.com/questions/65850388/how-can-i-create-a-summarized-table-that-keeps-all-columns-from-the-table-being
