Forum Discussion

TimPowerBi2's avatar
TimPowerBi2
Frequent Visitor
3 years ago
Solved

Get the first date for a name over multiple rows

Hello Power BI Community!   I am trying to get the earliest and latest date for every name in a timeseries table. I want to do this through a calculated column so I can run further analysis on the ...
Need Help
  • MBernalBI's avatar
    MBernalBI
    3 years ago

    Hello!!

     

    I hope that I can help you. I have created a calculated table. 

    Desired result = 
SUMMARIZE(Tabla,  
Tabla[Name],
Tabla[Date],
"Earliest", CALCULATE(MIN(Tabla[Date]), ALLEXCEPT(Tabla,Tabla[Name])),
"Latest", CALCULATE(MAX(Tabla[Date]), ALLEXCEPT(Tabla,Tabla[Name]))
)

     

    This is the result

     

     

    I hope that I have helped you.

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

you can create two column 

Latest =CALCULATE(MAX(Table[Date]),ALLEXCEPT(Table, Table[Name]))


Earliest =CALCULATE(MIN(Table[Date]),ALLEXCEPT(Table, Table[Name]))

you can get the required table