Forum Discussion

ArchStanton's avatar
ArchStanton
Icon for Power Participant rankPower Participant
30 days ago
Solved

Retrieving Values from Single Column

Hi, I have the following simple table in my Datamodel: Month                                       Active caseload 01 March 2026                                  100 April 2026                   ...
  • aswathimohan's avatar
    aswathimohan
    29 days ago

    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.