I have referenced the timestamp (a key from my D Table) by creating a column name “Timestamp Key”. From here I easily de-ref other values as “shift” and “ORDER ID”
e.g [Timestamp Key].[Shift] and [Timestamp Key].[Order ID] .
but when I tried to de-ref the “order value” using the same method it just couldn’t get it.
i made this through “part of” activated.
I have even went into doing Any and Select expression and still won’t give me the answer. No error. just blank.
I have tested to get Order ID and it returned the “correct ID”, but when I change and look for the “order value” instead it returned blank:
Any(Select(Dipstick[Order Diesel],[Order ID]=[_Thisrow].[Order ID])) this returns blank
Any(Select(Dipstick[Order ID],[Order ID]=[_Thisrow].[Order ID])) this returns the Order ID
what I am missing here?