Header name of the first non blank value in a row

[ashik1992]

I need a help to find the Header name of the first non blank value in a row and the last .

i mean,basically need to find the first working ddate of the consultant and last .

if it is excel or power bi. please help

emp	1-Jun	2-Jun	3-Jun	4-Jun	5-Jun	6-Jun	7-Jun	8-Jun	9-Jun	10-Jun	11-Jun	12-Jun	13-Jun	14-Jun	15-Jun	16-Jun	17-Jun	18-Jun	19-Jun	20-Jun	21-Jun	22-Jun	23-Jun	24-Jun	25-Jun
A	9	9	10	9			9	9	9	9	9			9	9	9	9	9			9	9	9	9	9
c	9	9	9	9			9	9	9	9	9			9	9	13	11	9			9	9	9	9	9
dad	9	8	10	7			9	10	9	8	8			10	10	8	10	9			9	10	9	10	8
x	8	9	9	9			9.5	10.5	9	9	1
adsa	10	8	10	10			11	11	11	11	11			11	11	11	11	11			10	10	10	10	10
cdfa	9	9	9	9			9	9	9	9	9			9	9	9	9	9			9	9	9	9	9
daaa	10	8	8	11			9	8	9	11	8			10	8	8	11	8			11	8	8	9	9
adfa	9	9	9	9	1		9	9	9	9	9	2		9	9	9	9	9	1		9	9	9	9	9
ffa	9	9	9	9			9	9	9	9	9			9	9	9	9	9			9	9	9	9	9
ddaaa	9	9	9	9			9	9	9	9	9			9	9	9	9	9			9	9	9	9	9
ffff
vvvv															9	9	9	9						9	9
ccccc	9	9	9	9			9	9	9	9	9			9	9	9	9	9			9	9	9	9	9
bbb	8	8	13	13			11	11	11	11	11			11	11	11	11	11			13	8	13	13	13

[amitchandak · Accepted solution]

@ashik1992 , Overall level

Min date = minx(allselected(Date), date[date])

Max date = maxx(allselected(Date), date[date])

At visual row level : means employee

Min date = calculate(Min(date[Date]), filter(allselected(Table), Table[Emp] =max(Table[Emp])))

Max date = calculate(Max(date[Date]), filter(allselected(Table), Table[Emp] =max(Table[Emp])))