Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
lnpapin
Helper I
Helper I

First date base on non blank value of a specific column

Hi, I am having trouble writing a mesure that will get me the first date base on a non blank value of a specific column

Here an exemple of my data: 

lnpapin_0-1616678703559.png

and the expected result would me something like that:

lnpapin_1-1616678741134.png

Thanks for your help!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

First N-Blank Date Value A= CALCULATE(MIN('Table'[Date]),FILTER(ALLEXCEPT('Table','Table'[Account]),'Table'[Value A]<>BLANK()))
First N-Blank Date Value B = CALCULATE(MIN('Table'[Date]),FILTER(ALLEXCEPT('Table','Table'[Account]),'Table'[Value B]<>BLANK()))

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

First N-Blank Date Value A= CALCULATE(MIN('Table'[Date]),FILTER(ALLEXCEPT('Table','Table'[Account]),'Table'[Value A]<>BLANK()))
First N-Blank Date Value B = CALCULATE(MIN('Table'[Date]),FILTER(ALLEXCEPT('Table','Table'[Account]),'Table'[Value B]<>BLANK()))

I have the exact scenario and I need to return the value A which is corresponding to the month in the result column. Possible?

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.