Forum Discussion

MiguelSaldana77's avatar
MiguelSaldana77
Icon for Resolver I rankResolver 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
Icon for Resolver I rankResolver I
3 years ago

I can not paste the pbix , any idea why ?

 

lbendlin's avatar
lbendlin
Icon for Super User rankSuper 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)