Forum Discussion

karlo's avatar
karlo
Frequent Visitor
6 years ago
Solved

DAX - Problem to identify previous record

Hi everyone,   I'm starting with DAX and I need your help, for a particular record I am trying to identify the previous record if the start date of the previous record is less. Also, if there is mo...
  • Anonymous's avatar
    Anonymous
    6 years ago

    karlo 
    Please create a measure 

    Measure = CALCULATE(CONCATENATEX('Table','Table'[PRODUCT],"-",'Table'[PRODUCT]),FILTER(ALLEXCEPT('Table','Table'[ID]),'Table'[START]<MAX('Table'[START])))

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

karlo 
Please create a measure 

Measure = CALCULATE(CONCATENATEX('Table','Table'[PRODUCT],"-",'Table'[PRODUCT]),FILTER(ALLEXCEPT('Table','Table'[ID]),'Table'[START]<MAX('Table'[START])))

 

  • karlo's avatar
    karlo
    Frequent Visitor
    6 years ago

    Excellent vimal_parmar, I'll try again

     

    Thank you very much!