FirstSortedValue using Aggr

rubenares — Sat, 16 Nov 2024 04:10:08 GMT

Hi all,

We have following dataset...

... and we need to show diferent measures when user select a date:

Last Date: SOLVED with..
- FirstSortedValue({<Date=>} Date, Aggr(Sum({<Date=>} Floor(Today())-Floor(Date)), Date, Name))

Max Qty Date: SOLVED, but with problems cause in the example the Qty is the same in all dates and we want in this case show last date among valid dates.
- FirstSortedValue({<Date=>} Date, -Aggr(Sum({<Date=>} [Qty]), Date, Name))

Max Qty Date Qty: SOLVED, but with the previous problem.
- FirstSortedValue({<Date=>} Aggr(Sum({<Date=>} [Qty]), Date, Name), -Aggr(Sum({<Date=>} [Qty]), Date, Name))

The result with previous measures is the following:

.. and data should be displayed are:

Select Date Qty: 0,6

Last Date: 31/3/2019

Last Date Qty: 0,6

Max Qty Date: 31/3/2019

Max Qty Date Qty: 0,6

Does anyone know to solve the problem with measures? Thanks in advanced!

topic FirstSortedValue using Aggr in App Development