Table from measures

[Thimios]

Hi all,

Would greatly appreciate your help with the following.

I have different measures calculated out of several table data in my model. All tables are connected to my Date table.

Lets call these measures: COS - Labor Burden, COS - Materials, COS - Subcontrators, etc.

I need to create a table in Power Query with these measures as rows and columns the 1st day of each month. Thus, Every time data get in the system, measures will be calculated and populate this table. 

Here is the desired outcome:

[Anonymous · Accepted solution]

HI @Thimios,

You can refer to the following blog to know how to create  matrix with custom field values:

Creating a “custom” or “hybrid” matrix in PowerBI  

Regards,

Xiaoxin Sheng