Forum Discussion

vinnyrigoni's avatar
vinnyrigoni
New Member
2 years ago
Solved

Sales Pace

Hello, I would like to create a sales rhythm in which I have the YEAR-MONTH values ​​in column 3, while in column 4 I have the accumulated. I would like to replace the values ​​equal to zero in colum...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi vinnyrigoni 

    You can refer to the pbix file attacted in the end.

    First create an index column in power query.



    Then using the following dax:

    Ending Balance2 = 
VAR _index = SELECTEDVALUE(Movements[Index])
VAR total= CALCULATE(SUM(Movements[Mov Existence]),FILTER(ALL(Movements),'Movements'[Index] <= _index))

RETURN total

     

     

    Result:

     

     

     

     

     

    Best Regards,

    Jayleny

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi vinnyrigoni 

You can refer to the pbix file attacted in the end.

First create an index column in power query.



Then using the following dax:

Ending Balance2 = 
VAR _index = SELECTEDVALUE(Movements[Index])
VAR total= CALCULATE(SUM(Movements[Mov Existence]),FILTER(ALL(Movements),'Movements'[Index] <= _index))

RETURN total

 

 

Result:

 

 

 

 

 

Best Regards,

Jayleny

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.