Forum Discussion

MiguelSaldana77's avatar
MiguelSaldana77
Resolver I
3 years ago

Acumulate Formula with conditions

Hi everyone, I have  a question about  a Calculate Measure.   In the next image, I have an example of the behavior that must had my Initial Balance and the Final Balance. I must say, that I have a...
Need Help
MiguelSaldana77's avatar
MiguelSaldana77
Resolver I
3 years ago

I can not paste the pbix , any idea why ?

 

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    Only Super Users can attach files.  Your sample data is ok, will check it later.

    • v-jingzhang's avatar
      v-jingzhang
      Community Support
      3 years ago

      Hi lbendlin 

       

      If you have time, can you help follow this thread? Thank you in advance. 

       

      Best Regards,
      Community Support Team _ Jing

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    Here is some sample DAX code:

     

    Initial Balance = 
    var d= min([Date])
    return calculate(sum([Amount]),[Date]<d)

     

    Final Balance = 
    var d= max([Date])
    return calculate(sum([Amount]),[Date]<=d)