Forum Discussion
How to return a previous measures cell value
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 ...
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)
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)