Matrix Report That Acts Like A SSRS / Excel Report

Hi,

Does anyone know what the best way to try to reproduce an Excel type report to Power BI?   The following is what the Excel looks like:

I have been able to do this with a Matrix but essentially I am unioning all the detail with a different record type and sub record type as an identifier.  However, the data set is large because it is essentially Income Statement data that is being pulled 8 or more times for each record type.   Thus, can you do this without so many union queries? 

Thanks! 

Thus,