powerbi - How can I create a summarized table that keeps all columns from the table being summarized?

Question

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

Answer 1

Waitting for answers