Fields from one table to create columns in the other

[paweln]

I have production batches in such table.

Every lot has to go through two sections of shop floor, section A (with machines A1, A2 etc.) and B (machines B1, B2, B3 etc). 

I need such table:

How to do it?

[PrashantSangle]

what is your expected output?

where you want to do it??

have you tried with pivot table 

take 2 dimension Batch No and Section 

measure : Count(Batch No)

or in 

Table

take Batch No as Dimension

Measure 1 : count({<Section={'A'}>}[Batch No])

Measure 2 : count({<Section={'B'}>}[Batch No]) 

Regards,

max

[IamAlbinAntony]

Try this,

=if(Count(Batch)=2,aggr(only({<Section={'A'}>}Machine),Machine),null()) for A

=if(Count(Batch)=2,aggr(only({<Section={'B'}>}Machine),Machine),null()) for B