How to return a previous measures cell value

Anonymous — Mon, 31 Aug 2020 17:31:14 GMT

Hi everyone, I have a table using measures to create calculated values. Ok, nothing new. The table is organized by a "Month Year" column ( I don't have a date field in the table). I do have a month number column. I want a third column (via a measure) that will replicate the previous month's value. I cant index the table as the Month Year values are not unique. Please see the table below to see what I need. Thank you very much for your help.

Month Year	Measure Value	Previous Measure Value
Aug 2016	25
Sep 2016	42	25
Oct 2016	17	42
Nov 2016	36	17
Dec 2016	5	36
Jan 2017	62	5

Re: How to return a previous measures cell value

Anonymous — Mon, 31 Aug 2020 19:10:04 GMT

everyone, I found a soultion that I want to share... here is the Measure with the working solution:

CALCULATE(COUNT('Monthly Data'[File Number]), 'Monthly Data'[Number of days of delinquency] = 0,

'Monthly Data'[Accounting Status] <> "Charge Off - Bankruptcy" &&

'Monthly Data'[Accounting Status] <> "Charge Off - Consumer Proposal" &&

'Monthly Data'[Accounting Status] <> "Charge Off - Fraud" &&

'Monthly Data'[Accounting Status] <> "Charge Off - Deceased",

--THE TOPN IS WHERE THE MAGIC HAPPENS!!!

TOPN(1,FILTER(ALLSELECTED('Monthly Data'),'Monthly Data'[Source Previous Month Calc] < MAX('Monthly Data'[Source Previous Month Calc])),'Monthly Data'[Source Previous Month Calc], DESC)

topic How to return a previous measures cell value in Community Feedback

How to return a previous measures cell value

Re: How to return a previous measures cell value