I have no idea what/where/how you are doing on this data source.
If you are asking ETL know-how, my answer is completely out of scope.
Anyways, I tried to get your max, min, avg for respective measure from big data.
Because all of your expected measure is aggregation of aggregation, then all the fields needs to set as table calculation.
Format matrix is completely different topic here.
All these fields are needed to be re-biuld with window calculations (4 x min,avg,max) = 12
Then add 12 calc fields with moving "View by dimension" to detail.
and change "ALL" the fields' table calc setting as blow.
Still the data is duplicated, then need to limit the view with index filter.
Main_table_calc.SM_10.3.twbx 5.2 MB