topic Get the most recent value from a numeric column in DAX Commands and Tips

Get the most recent value from a numeric column

GAETAN63 — Tue, 19 May 2020 14:06:10 GMT

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,

Re: Get the most recent value from a numeric column

Anonymous — Tue, 19 May 2020 16:37:29 GMT

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

Re: Get the most recent value from a numeric column

camargos88 — Tue, 19 May 2020 17:12:36 GMT

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:

Re: Get the most recent value from a numeric column

Anonymous — Wed, 20 May 2020 00:56:58 GMT

[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

Re: Get the most recent value from a numeric column

GAETAN63 — Wed, 20 May 2020 11:18:10 GMT

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/33602

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

see you,