Guidance with specific dynamic table

[Inetegrator]

Hi Community!!

Hope you are doing fine! This time i need your knowledge to check if it is possible to make an specific table in Power Bi Desktop. Let me explain what I need, maybe you can guide me or even give me a recommendation:

I need to make a table that can looks like this one created on Excel 

the data base come from  google spreadsheet. The first 5 rows comes from one sheet called "Order" and the table information cames from other sheet called "Inspections" (the 5 first rows i want to use controls that can depends between them automatically to filter the information below of course( the table itself))

If you notice the data collects information for row but the final table requieres samples in columns and the rest of information in the first columna as you see in the first screenshot. 

I already connect the data from the spreadsheet and for the  but I dont know hoy to create the table with this sample column requirement. Also my simple table for Power bi default have alfabetic organization but this change all the structure I really need. the final Idea with this type of dynamic table is to connect it with a final app for client who need to check his order and sample inspections. 

This is the latest table I create with a transpose from the data using sample columns as header but some samples has the same name and to used it in the table is not practical because I think I would need to check manually each one every time the data updated itself, right? or there is another way to automatize this step too?

Please, any Idea you can gave me is usefull to proceed, check if it is possible or tried with other tools,

Regards!!

[amitchandak]

@Inetegrator , if these are some power query steps, they will repeat with each data load. But if something which will change with every load and you are not aware, I doubt you can automate.

Can you explain with more specific example

[Inetegrator]

Hi thanks for take a look!

I'm new using power query complex codes, but I think there is the answer for my table using pivot maybe. I let you an example data spreadsheet. Inspections sheets have order ID (reference to ID from Order sheet) and InspImages have Inspection ID (reference to Inspections sheet) with this type of data source i need to recreate the table view as appear on the excel screenshot. 

any idea how can i proceed? you think is possible have this type of table on power bi?

[v-kelly-msft]

Hi @Inetegrator ，

I think you could use matrix and measure to realize it ,no need to pivot table.

My .pbix file is attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!