topic Re: Last value in row in DAX Commands and Tips

Last value in row

MM1984 — Fri, 28 Jan 2022 17:25:10 GMT

Hey,

Is there a function to get the last value in a row?

Example PrimaryKey / Date1/ Date2/ Date3/ Date4 xx1 / 28.01.2020 / 01.01.2020

xx2 / 02.02.1922/ 10.08.2022/ 03.04.2011

DAX function last value for xx1 = 01.01.2020 For xx2 = 03.04.2011

Thanks a lot

marius

Re: Last value in row

ValtteriN — Fri, 28 Jan 2022 18:21:41 GMT

Hi,

There isn't a direct function. In these kind of cases I would unpivot the data and use LASTNONBLANK while considering the key as a filter.

Re: Last value in row

v-yanjiang-msft — Thu, 03 Feb 2022 09:04:00 GMT

Hi MM1984 ,

According to your description, here's my solution.

1.In Power Query, select all date columns at the same time, then click Unpivot Columns.

Get the following table.

2.Add an index column.

3.Create a measure.

Last date= MAXX ( FILTER ( 'Table', 'Table'[Index] = MAXX ( FILTER ( ALL ( 'Table' ), 'Table'[PrimaryKey] = MAX ( 'Table'[PrimaryKey] ) && 'Table'[Value] <> BLANK () ), 'Table'[Index] ) ), 'Table'[Value] )

4.Put PrimaryKey and the measure in a table visual, get the expected result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.