Get the most recent value from a numeric column

[GAETAN63]

Hello, I have a table with lower and upper limits given for specific products (mix name) and measurements method (propertie). Those limits can change with time, and I'm looking for a DAX measurement to give the last limits, I mean the one from the most recent date indication. I tried LASTNONBLANK function on my lower (TI) and upper (TS) columns but it sorts those numeric column from mini to maxi and give me... the maxi! Any solution to identify the most recent limits from my table?

Thanks,Summury table given by LASTNONBLANK DAX functions and data source table

[GAETAN63 · Accepted solution]

Hi all! I found a great solution on this last post: https://community.powerbi.com/t5/Desktop/How-can-I-get-the-last-value-of-a-column-in-my-dataset/td-p... 

I put the solution in an updated picture, thanks to all answers below!

see you,

[Anonymous]

[Last TI] =
if( 
	HASONEVALUE( T[Mix Name] )
	&& HASONEVALUE( T[Propertie] ),

	var __rows =
		topn(1,
			YourTable,
			YourTable[Date Fabrication],
			DESC
		)
	return
		if(
			COUNTROWS( __rows ) = 1,
			MAXX(
				__rows,
				YourTable[TI]
			)
		)
)

[Last TS] =
if( 
	HASONEVALUE( T[Mix Name] )
	&& HASONEVALUE( T[Propertie] ),

	var __rows =
		topn(1,
			YourTable,
			YourTable[Date Fabrication],
			DESC
		)
	return
		if(
			COUNTROWS( __rows ) = 1,
			MAXX(
				__rows,
				YourTable[TS]
			)
		)
)

Best

D

[camargos88]

Hi @GAETAN63 ,

Create this new column: 

LastItem = IF('Table'[Date] = CALCULATE(MAX('Table'[Date]); filter('Table'; 'Table'[Name] = EARLIER('Table'[Name]))); 1; 0)

Filter the visual:

[harshnathani]

Hi @GAETAN63 ,

I am not very clear as to what is your expected outcome. However, you can create a Table.

New Table = Filter ('Table', 'Table'[DateFabrication] = Min('Table'[Data Fabrication])

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!