Forum Discussion

GAETAN63's avatar
GAETAN63
New Member
6 years ago
Solved

Get the most recent value from a numeric column

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

LASTNONBLANK

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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!!

  • camargos88's avatar
    camargos88
    Icon for Community Champion rankCommunity Champion
    6 years ago

    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:
     
     
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    [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