cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ashik1992
Helper I
Helper I

Header name of the first non blank value in a row

 

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

 

emp1-Jun2-Jun3-Jun4-Jun5-Jun6-Jun7-Jun8-Jun9-Jun10-Jun11-Jun12-Jun13-Jun14-Jun15-Jun16-Jun17-Jun18-Jun19-Jun20-Jun21-Jun22-Jun23-Jun24-Jun25-Jun
A99109  99999  99999  99999
c9999  99999  9913119  99999
dad98107  910988  10108109  9109108
x8999  9.510.5991              
adsa1081010  1111111111  1111111111  1010101010
cdfa9999  99999  99999  99999
daaa108811  989118  1088118  118899
adfa99991 999992 999991 99999
ffa9999  99999  99999  99999
ddaaa9999  99999  99999  99999
ffff                         
vvvv              9999     99
ccccc9999  99999  99999  99999
bbb881313  1111111111  1111111111  138131313
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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])))

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@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])))

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!