Forum Discussion
Solved
Previous value not working??
Hi there, I have a simple table which outlines a measure name, the RAG of that measure against a date (quarter ending date). The table doesnt have dates for every day, just on the quarter endi...
Hi,
This calculated column formula works
Column = LOOKUPVALUE('RAG by measure ID'[RAG],'RAG by measure ID'[Measure ID],'RAG by measure ID'[Measure ID],'RAG by measure ID'[Date],CALCULATE(MAX('RAG by measure ID'[Date]),FILTER('RAG by measure ID','RAG by measure ID'[Measure ID]=EARLIER('RAG by measure ID'[Measure ID])&&'RAG by measure ID'[Date]<EARLIER('RAG by measure ID'[Date]))))Hope this helps.
Greg_Deckler
I tried this but didnt work 😞
*Previous rag =
VAR __Date = ALL('QR Measures'[Date])
VAR __Measure = ALL('QR Measures'[Id])
VAR __PreviousDate =
MAXX ( FILTER ( 'QR Measures', 'QR Measures'[Date] < __Date && 'QR Measures'[Id] = __Measure ), 'QR Measures'[Date] )
RETURN
MAXX (
FILTER ( 'QR Measures', 'QR Measures'[Date] = __PreviousDate && 'QR Measures'[Id]= __Measure ),
'QR Measures'[RAG]
)
Cbutler So can you post your sample data as text?