Forum Discussion

Yon_Yamas's avatar
Yon_Yamas
Regular Visitor
2 years ago
Solved

Last middle last date

Hi, My data base is like this and i would like to had a column filled with "First" when this is the first "date_debut" of the same group of "id_membre" ; "Last" if this is the last "date_début" of t...
  • FreemanZ's avatar
    FreemanZ
    2 years ago

    hi Yon_Yamas ,

     

    try to add a calculated column like:

    column =
    VAR _table = FILTER(data, data[id_membre]=EARLIER(data[id_membre]))
    VAR _first = MINX(_table, data[date_debut])
    VAR _last = MAXX(_table, data[date_debut])
    RETURN
    SWITCH([date_debut], _first, "First", _last, "Last", "Renew")
Yon_Yamas's avatar
Yon_Yamas
Regular Visitor
2 years ago

Thank you so much !