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

arb1962's avatar
arb1962
New Member
3 years ago

Hi Amit,

Here ia a scenario

Column 1 = date (take any random  years)

Column 2 to 4 = F1 F2 F3 ....F10 (platfroms) corresponding tweleve dates would have random 0 or 1 as an input for F1, F2 , F3 (represents 1 = issues, 0 = no issues) 

Column 5 - 8 are observations with heading Item 1 to Item 4. 

Item1 - Good, bad and Ok

Item2 - Low, Medium, High

Item3 - TK1, TK2, TK3

Item4 - BD1, BD2, BD3

 

All input for Item1 to Item4 random

 

I am looking for results based on Items versus Platfrom based on dates (yearly, quarterly, montly, weeky and even daily)

 

I tried to solve by unpivoting the platfroms and went for a solution but I am not getting the result. 

 

Could you help me out