Want to find the price of latest date or recent date

[RishabhTFC]

Hello Guys,

I want to make a bar graph that shows the price of vendors on the latest date.

this is the given sample to try. I tried firstsortedvalue function but it only shows valut of only V1 all others vendors are showing "-".

Please help me to solve this issue. 

Vendor_id	Date	Price
V1	20140601	155
V1	20151001	158.56
V1	20180101	93
V2	20100501	171.43
V3	20110718	121
V2	20170501	55
V1	20110718	118

[Chanty4u]

the maximum

1. Sum(Aggr(FirstSortedValue(Price, -Date), Vendor_id)) 

[rubenmarin]

Hi Subham, firstsortedvalue() should work, unles a vendor has many different values for the first or last date.

Last value: FirstSortedValue(Price, -Date)

First value: FirstSortedValue(Price, Date)

[Chanty4u]

Please close the thread if you got the correct answer

[RishabhTFC]

Thank you very much, IT works perfectly. but there is one problem too. This is my Table

And I got the right:

    

But the problem is I want to make a KPI and want to make some operations with that number "62.61"  (The sum of all the price of all the  Part_id of that vendor) I want it to multiply Quantity(Qty) with that 62.61 and show it in a KPI. 

[sasikanth]

HI,

Try below expression

=Sum(Aggr(Sum({<Date=

{$(=concat(chr(39)&aggr(distincmax(num(Date)),Vendor_id)&chr(39),','))}>}Price),Vendor_id))

Thanks,

[RishabhTFC]

No it's not working

[sasikanth]

Check the expression once there is a space between Distinct  & max

[RishabhTFC]

[rubenmarin]

Hi, can you try?:

Sum(Aggr(FirstSortedValue(Price, -Date), V_id, Part_id))*Sum(Qty)