Find Current Value and Previous Value

Hi bhmiller89

It is not clear for me.

I don't need MAX Rag_Value, I need the Rag_Value for the MAX DATE 

AMBER NormalizedMRR$Current = CALCULATE(SUM(vw_OperationalJobsWithMRR[NormalizedMRR]), MAX(RAGandMRR[RAG_Value])= 2)

From above, it seems you need Rag_Value=2 when date is the MAX DATE, you could try this formula

Max date=CALCULATE(MAX(RAGandMRR[Date]),ALL(RAGandMRR))

AMBER NormalizedMRR$Current = CALCULATE(SUM(vw_OperationalJobsWithMRR[NormalizedMRR]), FILTER(ALL(RAGandMRR),RAGandMRR[RAG_Value]= 2&&RAGandMRR[Date]=[Max date]))

Then what do you mean by this sentence

The RAG_Value can range from 0-3. I need to calculate measures for MRR based on current RAG Value and Previous RAG Value

Best Regards

Maggie