Get value of an item by lastDate

[FARQLIK]

Hello Community ,

I have an item I want to get the price By Dataaread(VMX/VTU) and for each Dataaread the last datecreation(MAX) in the load Script .

Thank you for your Help 

Best Regards 

[Kushal_Chawda]

@FARQLIK  try below

Data:
LOAD ItemNumber,
Dataaread
Date
...
....
FROM Table;

left join(Data)
load ItemNumber,
Dataaread,
max(Date) as Date
1 as Latest_Date_Flag
resident Data
group by ItemNumber,Dataaread;

Then on front you can write the expression for price as below

=Sum({<Latest_Date_Flag={1}>}Price)