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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

New Member

## Decreasing total number over the course of weeks

Hello All,

I have a list of items that are being "closed" over the course of weeks (CW1, CW2...). How do you create function (probably some measure / calculation) for running total.

for example CW1 item open and being closed at CWn.

I try to create decreasing line chart on total number from CW1 toward CWn.

I thought of creating columns for each week and count the open items however I cannot figure out how I can have CW1 to CWn axis.

Any help would be much appreciated!

Thank you in advance!

2 REPLIES 2
Employee

Sounds like you just need a running total (cumulative) but in reverse.  If you share some info about the structure of your tables, we can suggest some calculations 🙂

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

New Member

Hi Phil,

Thank you for your answer, it indeed sounds what exactly I need.

I copied the part of table. I need to develop report on a weekly basis and show total open numbers dropping.

When a date entered, Status turns into Closed.

An item opened, for example, 2-Dec-17 would be open several weeks until its closed.

How I can create axis (weekly) starting from for example 10-Feb-18 and show total numbers of Open items decreasing over the course of weeks.

Thank you once again, I greatly appreciate if you could solve this one for me. I am tearing my hair out since couple of days.

REG DATE     DATE COMPLETED  Status

 2-Dec-17 21-03-18 Closed 24-Dec-17 21-03-18 Closed 24-Dec-17 21-03-18 Closed 28-Dec-17 Open 28-Dec-17 21-03-18 Closed 26-Nov-17 27-02-18 Closed 26-Nov-17 27-02-18 Closed 26-Nov-17 27-02-18 Closed 26-Nov-17 27-02-18 Closed 26-Nov-17 27-02-18 Closed 26-Nov-17 27-02-18 Closed 1-Jan-18 Open 1-Jan-18 20-03-18 Closed 8-Oct-17 21-03-18 Closed 28-Dec-17 21-03-18 Closed 28-Dec-17 21-03-18 Closed 16-Nov-17 21-03-18 Closed 16-Nov-17 21-03-18 Closed 29-Oct-17 27-02-18 Closed 9-Dec-17 19-02-18 Closed

## Helpful resources

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors