Forum Discussion

rgalvez's avatar
rgalvez
Frequent Visitor
3 years ago
Solved

DAX for earliest value

Hello experts! My dataset is built of three tables: Users, Mastery and Exams. The Users table is the link (one-to-many relation) between Mastery and Exams tables, as follows:   The expected...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    rgalvez , a new column based on what I got

     

    diff =

    var _max = maxx(filter(Table, [Rep Id] = earlier([Rep id])  && [Intial Date] < earlier([Intial date]) ), [Intial  Date])

    return

     maxx(filter(Table, [Rep Id] = earlier([Rep id])  && [Intial Date] =_max ), [Score]) - [Score]

     

    Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8

amitchandak's avatar
amitchandak
Super User
3 years ago

rgalvez , a new column based on what I got

 

diff =

var _max = maxx(filter(Table, [Rep Id] = earlier([Rep id])  && [Intial Date] < earlier([Intial date]) ), [Intial  Date])

return

 maxx(filter(Table, [Rep Id] = earlier([Rep id])  && [Intial Date] =_max ), [Score]) - [Score]

 

Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8

rgalvez's avatar
rgalvez
Frequent Visitor
3 years ago

Thanks! Not exactly what I was asking for, but the link to the Earlier approach was very useful.