Forum Discussion

alexeisenhart's avatar
alexeisenhart
Resolver I
8 years ago
Solved

Calucated Columns for Aggregate Values From Another Dataset

I'm sure that this is a basic question but I can't find the solution anywhere online.   I have two datasets: BoxMovement - This is the set of where boxes are moving through a system BoxID, Movem...
Need Help
  • alexeisenhart's avatar
    alexeisenhart
    8 years ago

    Thanks for your response Greg. MAXX might work also but I got it working with a Calculate and Filter. I don't know why it took so long for the use of these functions to sink in.

     

    = CALCULATE(MAX(BoxMovement[Datetime])
         , FILTER(

              BoxMovement, BoxMovement[BoxID] = ShippedBox[BoxID] && LEFT(BoxMovement[From Location], 5) = "ABCDE")
         )

    )

     

    I found that LOOKUPVALUE was also useful to find the other fields from the record matching the datetime that was returned.

alexeisenhart's avatar
alexeisenhart
Resolver I
8 years ago

Thanks for your response Greg. MAXX might work also but I got it working with a Calculate and Filter. I don't know why it took so long for the use of these functions to sink in.

 

= CALCULATE(MAX(BoxMovement[Datetime])
     , FILTER(

          BoxMovement, BoxMovement[BoxID] = ShippedBox[BoxID] && LEFT(BoxMovement[From Location], 5) = "ABCDE")
     )

)

 

I found that LOOKUPVALUE was also useful to find the other fields from the record matching the datetime that was returned.