I am so lost.
I dont really know how I would search for a simular problem since i dont know how to explain it without a visual aid.
I am trying to get the value from the row with the latest date. (Row.2)
Row.1 is the actuall event date (delivery date),
I need to get the latest Real_TB1 in a calculated column Get Latest Real_TB1 (the last column)
Somehow I guess I need to use use MAX EventDate where VehicleNumber = VehicleNumber and then get Real_TB1 from that.
This table has around 300.000 rows
|EventDate||Delivery_count||Invoice_count||Order_count||Real_TB1||VehicleNumber||Get Latest Real_TB1|
Solved! Go to Solution.
Column = VAR __MaxDate = MAX('Table'[EventDate]) VAR __MaxDateRealTB1 = MAXX(FILTER(ALL('Table'), [EventDate] = __MaxDate), [Real_TB1]) RETURN __MaxDateRealTB1
Watch this video if you need more help, especially the last example, Double Lookup.
Thx for the quick respons!
That didnt really work but somehow I manage to get it to work with this.
I will look at the video tomorrow.
Get Latest Real_TB1 = Var GetDate = CALCULATE( MAX( Fact_KobraRetail[EventDate] ), FILTER ( ALL (Fact_KobraRetail ), Fact_KobraRetail[VehicleNumber] = EARLIER( Fact_KobraRetail[VehicleNumber] ) ) ) Var Result = CALCULATE( MAX( Fact_KobraRetail[Real_TB1] ) , FILTER( ALL ( Fact_KobraRetail ), Fact_KobraRetail[VehicleNumber] = EARLIER( Fact_KobraRetail[VehicleNumber] ) ) , FILTER( ALL ( Fact_KobraRetail ), GetDate = Fact_KobraRetail[EventDate] ) ) RETURN Result