Finding the value at the earliest date in a column

[Anonymous]

Hello, 

I have made a column that only gives me the values from a table for the past two weeks, however the rows before that point are all null. Because of this I haven't been able to figure our a way to use the EARLIEST function. When I use the FIRSTNONBLANK value it only gives me the minimum value from the time span. Is there is a solution using what I have in place or a better solution that will give week the value of a column from two weeks ago the current date?

[Ahmedx]

You can get rid of empty rows, but you still need an index column.
You can do all this in power query

[Ahmedx]

Can you please share your demo input and expected output!

[Ritaf1983]

Hi @Anonymous 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[Anonymous]

@Ahmedx , @Ritaf1983,

This is what my current Custom columns look like. I would like to make a measure that returns the value from the first value in each row and a measure to return the last row, in row 2 for example I would like to return 829.82 and 881.70 respectively. The issue I am running into due to the blank rows above and below causing EARLIEST() and EARLIER() not to work and FIRSTNONBLANK() returns 800.52 rather than the number I'd like returned.

Trend Period	Effluent Trend	Concentration Trend	Flow Trend	Loading Trend	TPD Trend	Temp Trend
10/3/2023	829.8264	2166.667	813.223	13300.53	887	85
10/4/2023	933.5718	2300	777.967	13592	759	86
10/5/2023	800.5275	2233.333	743.501	12718.76	853	86
10/10/2023	868.0511	2200	839.324	14031.69	881	80
10/11/2023	817.207		771.668		860	81
10/12/2023	881.7022		850.911		873	81