Forum Discussion

Alopez11's avatar
Alopez11
Regular Visitor
3 years ago
Solved

Get the previous date on the data set

HelloI'm having troubles with a Dax. I have a data set that show when a field was irrigated and how long it was the irrigation period as you can see i¿on the following data set. I need to...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi

     

    First create a ranking column on your table

    RankAgricola =

    rankx(filter(Feuil4,Feuil4[Agricola]=EARLIER(Feuil4[Agricola])),Feuil4[Fecha])
     
    And after you can display it directly

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi

 

First create a ranking column on your table

RankAgricola =

rankx(filter(Feuil4,Feuil4[Agricola]=EARLIER(Feuil4[Agricola])),Feuil4[Fecha])
 
And after you can display it directly