Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good afternoon guys, are there something wrong with my syntax? Thanks!
try below
=FirstSortedValue(Key,-[FoB Price],1)
Try
=FirstSortedValue(Distinct Key,-[FoB Price],1)
or
=FirstSortedValue(Distinct Key,[FoB Price])
Or
Concat(Distinct If([FoB Price] = Min(Total [FoB Price]), Key),', ')
or
Concat(Distinct If([FoB Price] = Max(Total [FoB Price]), Key),', ')
If you have two highest [FoB Price] value, the below expression will return null
=FirstSortedValue(Key,-[FoB Price],1)