Restructuring data

[Anonymous]

Hello All,

i would like to join two data sets based on the  Start and End Dates 

the first has order information;

Process Order Number

Start Date

End date

the second has process information;

Temperature

Pressure

Timestamp

How may i join the data so  i can see the temperature and pressure between the Start  End date of each order?

very grateful

Miguel

[amitchandak]

Please take care of the row context. You can have a new Measure

Sumx(filter(Temperature,[Timestamp]>=min(order [Start Date]) && [Timestamp]<=max(order [End  Date])),process [Temperature])