Forum Discussion
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 ...
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.
Apologies for the poor formatting upon uploading.....