Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX Calculated Column

Hi, this is my request:   I need to find [Date] of the previous row by date (highest date less than the current date) adding these conditions:  [First_Parameter] of this row must be equal to [Fir...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Try a new column like, you can add condition using && (and) || or , inside the same filter

     

    Last Date Time = maxx(filter(table,table[Date Time]<earlier(table[Date Time]) && table[param1] =earlier(table[param1]) && table[A] =earlier(table[A])),table[Date Time])
    Max value = maxx(filter(table,table[team] =earlier(table[team]) && table[A] =earlier(table[A])),table[B])

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you all guys, your advices helped me a lot!

 

This worked:

MAXX(FILTER(Table, Table[Data Inserimento] < EARLIER(Table[Data]) && Table[First] = EARLIER(Table[First]) && Table[Second] <> EARLIER(Table[Second])), Table[Data])