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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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