Forum Discussion

Aark's avatar
Aark
Regular Visitor
4 years ago

Cumulative total with a hard twist

I am new to powerbi and I am unable to solve this question below. Thank you for looking into my question. I have two year month columns(eg: Mar_2021), one is the start month and the other is the end ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Try these dax：

China Running Total = CALCULATE(SUM('Table'[Sales]),'Table'[Region] = “China”);
Finland Running Total = CALCULATE(SUM('Table'[Sales]),'Table'[Region] = “Finland”);
Brazil Running Total = CALCULATE(SUM('Table'[Sales]),'Table'[Region] = “Brazil”);
Running Total Sales= [China Running Total] + [Finland Running Total] + [Brazil Running Total]

  • Aark's avatar
    Aark
    Regular Visitor
    4 years ago

    Hi. thanks a lot for your suggestion. But doing cumulative sum is not the main problem, subtracting the cumu sum when it ends according to the end date is the problem. I have to take into account both the start date and end date in one column as I have shown in the output table and accordingly add the subtract the sales.