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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

Top Solution Authors