FirstsortedValue(Aggr())

[bmensing]

Dear Community,

the schema for the database is as follows:

order id | date of production | date of material demand | date creation of material demand | time creation of material demand

24555     01.02.2018              14.02.2018                       02.02.2018                                      14:45

24555     01.02.2018              16.02.2018                       03.02.2018                                      12:01

24555     01.02.2018              18.02.2018                       03.02.2018                                      14:03

24555     01.02.2018              23.02.2018                       01.02.2018                                      18:20

24555     01.02.2018              22.02.2018                       01.02.2018                                      18:40

in my table the Dimension should be "date of material demand" and the value should be the last data set

order id | date of production | date of material demand | date creation of material demand | time creation of material demand

24555     01.02.2018              22.02.2018                       01.02.2018                                      18:40

like

if(date creation of material demand = date of production, then take the latest value of "date of material demand" according to the time (last column)

[sunny_talwar · Accepted solution]

Check the attached out

[bmensing]

that's it - thank you so much