Forum Discussion

yfquirogah's avatar
yfquirogah
Helper I
5 years ago
Solved

Earliest Date with the same value

Hi everybody,  I have a question regarding a calculated column that I haven't been able to figure out. I have a table similar to this: Upload Date ID Person   Grade 1/03/2020 32117464   ...
Need Help
  • DataInsights's avatar
    DataInsights
    5 years ago

    Hi yfquirogah,

     

    Try these calculated columns. (This is m/d/yy format.)

     

    Start Date Grade = 
VAR vPerson = Grades[ID Person]
VAR vGrade = Grades[Grade]
VAR vTable =
    FILTER ( Grades, Grades[ID Person] = vPerson && Grades[Grade] = vGrade )
VAR vResult =
    CALCULATE ( MIN ( Grades[Upload Date] ), vTable )
RETURN
    vResult

Time with the same Grade (Months) = DATEDIFF ( Grades[Start Date Grade], Grades[Upload Date], MONTH )

     

     

DataInsights's avatar
DataInsights
Super User
5 years ago

Hi yfquirogah,

 

Try these calculated columns. (This is m/d/yy format.)

 

Start Date Grade = 
VAR vPerson = Grades[ID Person]
VAR vGrade = Grades[Grade]
VAR vTable =
    FILTER ( Grades, Grades[ID Person] = vPerson && Grades[Grade] = vGrade )
VAR vResult =
    CALCULATE ( MIN ( Grades[Upload Date] ), vTable )
RETURN
    vResult

Time with the same Grade (Months) = DATEDIFF ( Grades[Start Date Grade], Grades[Upload Date], MONTH )