Repeat the most recent data point and corresponding month.

Add1 — Tue, 30 May 2023 18:04:35 GMT

I community. I need a bit of guidance. I have this dataset within the screenshot. I need to create a dynamic way to pull the most recent Preventative Maintenance numbers and the corresponding month when updated data is provided. In the screenshot, is what I want my final result to be... repeating Oct:343, until someone actually updates the table.

Below is the code that I created so far.

Any assistance would be great!

Thank you

3 Test = VAR LatestPMValue =

VAR MaxSortOrder = MAX('Facilities - Test'[Sort Order])

VAR Index = 1

VAR LatestPMValue2Measure2 = lookupvalue('Facilities - Test'[Preventative Maintenance],'Facilities - Test'[PMIndex],max('Facilities - Test'[PMIndex])) VAR PrevMaintenance =

LOOKUPVALUE(

'Facilities - Test'[Preventative Maintenance],

'Facilities - Test'[Sort Order],

MaxSortOrder - Index

)

VAR Month =

LOOKUPVALUE(

'Facilities - Test'[Month],

'Facilities - Test'[Sort Order],

MaxSortOrder - Index

)

VAR Result =

IF(

ISNUMBER(PrevMaintenance),

LEFT(Month, 3) & ": " & PrevMaintenance,

BLANK()

)

RETURN

Result

RETURN

LatestPMValue

Re: Repeat the most recent data point and corresponding month.

Add1 — Wed, 31 May 2023 03:06:18 GMT

I found the solution. I created a calculated table that pulled in the sort order, month, and preventative maintenance. I also added a column that produces the needed result. Then I created a DAX measure used the lookupvalue function to pull the last data point.

topic Re: Repeat the most recent data point and corresponding month. in DAX Commands and Tips

Repeat the most recent data point and corresponding month.

Re: Repeat the most recent data point and corresponding month.