Forum Discussion
ArchStanton
Power Participant
Power ParticipantRetrieving Values from Single Column
Hi, I have the following simple table in my Datamodel: Month Active caseload 01 March 2026 100 April 2026 ...
I have realised my mistake and deleted that post. I had also tried a solution as
Current Total = VAR _T = TOPN( 1, FILTER(CaseLoad,CaseLoad[Active Caseload]<>BLANK()), MONTH(CaseLoad[Month Year]),DESC) RETURN MAXX(_T,CaseLoad[Active Caseload])Previous Total = VAR _T = TOPN( 2, FILTER(CaseLoad,CaseLoad[Active Caseload]<>BLANK()), MONTH(CaseLoad[Month Year]),DESC) VAR _previous_date = MINX(_T,CaseLoad[Month Year]) RETURN CALCULATE(SUM(CaseLoad[Active Caseload]),CaseLoad[Month Year]=_previous_date)Is this a right approach.
ArchStantonPower Participant
Power ParticipantI've retrieved the latest figure using this DAX which works, how can I get the value before it (the prior month)?
Current Total =
VAR _lastdate =
CALCULATE(MAX('Caseload'[Month]),
FILTER('Caseload','Caseload'[Active Caseload] <> BLANK() )
)
RETURN
CALCULATE(
MAX('Caseload'[Active Caseload]),
FILTER('Caseload', 'Caseload'[Month] = _lastdate)
)