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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.