Hi guys, I've the following dataset that shows me the numbe of consumed and losted tickets in last 4 years. And I know that I have 32 tickets consumed for the next year.Tickets_ConsumedYearTickets_LostedYear102017320172520163520168201531201512014122014 And I'm trying to calculate the following formula in PowerBI:Tickets_ConsumedYearTickets_LostedYear Result10201732017 39 (32+10-3)252016352016 29(39+25-35)82015312015 6(29+8-31)12014122014 -5(6+1-12) How do I get the result:Current_Number of Tickets Consumed = 32Number of Tickets Consumed;Number of Tickets Losted; How can I do this using PowerBI? I can share the excel to see what I'm calculating Thanks

Hi SaCvP125 Try this measures... Total Consumed = SUM(Table1[Tickets Consumed]) Total Losted = SUM(Table1[Tickets Losted]) Current Number = 32 Result = var actualyear = FIRSTNONBLANK(Table1[Year];1) return CALCULATE([Current Number] + [Total Consumed] - [Total Losted];ALL(Table1);Table1[Year]>=actualyear) and this is the final result... I hope this helps RegardsBILASolution

Calculations with previous row | Microsoft Fabric Community

Forum Discussion

Related content

Facing challenge to calculate previous year QTD

Previous Month's MTD calculation

previous month calculation

Slow visual calculation (PREVIOUS and RUNNINGSUM)

Previous 6 months DAX calculation