Forum Discussion
JeevanMallya
Resolver II
Resolver IINeed a Column that adds reported Cumulative defects
I have a Table with Reported Defects and I want to create a New column that shows Cummulative by Considering ISSUE_KEY Columns with actual defects reported and ignoring null.I have added index column...
Thank you
danextian
Super User
Super UserHi JeevanMallya
Looking at the two tables, I don't see any difference.
JeevanMallyaResolver II
Resolver IIThere is a difference.REPORTED_CUMMULATIVE_ISSUE_KEY is a column with cummulative of ISSUE_KEY
- danextian
Try this:
Cumulative Count = VAR _Tbl = FILTER ( 'Project', Project[PROJECT_KEY] = EARLIER ( Project[PROJECT_KEY] ) && Project[Index] <= EARLIER ( Project[Index] ) --only index with less than or equal to current row index && NOT ( ISBLANK ( Project[ISSUE_KEY] ) ) ) RETURN SUMX ( _Tbl, [CREATED_COUNT] )- JeevanMallya
Thank you