table.selectrows custom colum results in "too complex to display"

[Anonymous]

Hello everyone

I got two tables which have no relationship with each other but I need to get a ID from one to another table.

I merged the two tables based on the unit, respectively the equipment.unit. The units are not unique values, because of that the follwing table resulted with multiple entries of different modules with a unit and its startUsage time. The merged table has the activateTime and deactivateTime for each operation with a uniqueBatchID.

Now I would like to get the batchID which was runnig when the usage started. For that I wrote the following query:

= Table.AddColumn(#"Merged Queries", "Custom", each let
   changedate = [startUsage]
   in
   Table.SelectRows ([RecipeAction], [activateTime]<= changedate and [deactivateTime] >= changedate))

But that always results in "Preview.Error: The current preview value is too complex to display." for the new column.

I don't really understand that, can somebody help me?

Best,
Matthias

[Anonymous · Accepted solution]

FYI I just had to delete / reduce the dimensions of the merged table now it's working.