Forum Discussion
ArchStanton
Power Participant
30 days agoRetrieving Values from Single Column
Hi, I have the following simple table in my Datamodel: Month Active caseload 01 March 2026 100 April 2026 ...
- 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.
v-achippa
Community Support
27 days agoHi ArchStanton,
Thank you for reaching out to Microsoft Fabric Community.
Thank you Praful_Potphode, ShahRukhSameer, Ashish_Mathur and ShivekMaharajGilbertQ for the prompt response.
As we haven’t heard back from you, we wanted to kindly follow up to check if the response provided by the user's for the issue worked? or let us know if you need any further assistance.
Thanks and regards,
Anjan Kumar Chippa