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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

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
FabCon Global Hackathon Carousel

FabCon Global Hackathon

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

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.