Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
FairyDeveloper
Frequent Visitor

Cumulative amount taking into account opened/closed date

Dear, 
Could you please help me to create Dax formula for the case described below?  Tried a lot of times but no success.
I need to calculate cumulative amount of open incidents for each day and take into account the date open and closed.
For example:

FairyDeveloper_0-1681590450592.png

 

Appreciate your help!

2 REPLIES 2
tamerj1
Super User
Super User

@FairyDeveloper 

Please try

Cumulative Amount =
VAR CurrentDate =
MAX ( 'Calendar'[Date] )
RETURN
COUNTROWS (
FILTER (
ALL ( Incidents ),
Incidents[Incident Open] <= CurrentDate
&& COALESCE ( Incidents[Incident Closed], TODAY () ) > CurrentDate
)
)

@tamerj1 , thanks a lot for help! now the amount is correct. 😍
But there is one more problem I've faced - it is not possible to divide the ticket amount per categories (which also exist in the main "Incident" table), the result is like this:

FairyDeveloper_0-1681590132485.png

Could you please advise how to fix this problem?



Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.