Need equivalent table built in PBI without loading table in data.

I have a table created using SUMIFS and AVERAGEIFS and need the same logic created in PBI to create the same table. I do not want to load the table itself... need the PBI logic on how to create.