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.

Reply
flausbert
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
Phil_Seamark
Employee
Employee

Hi @flausbert

 

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!

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-18Closed
24-Dec-17 21-03-18Closed
24-Dec-17 21-03-18Closed
28-Dec-17  Open
28-Dec-17 21-03-18Closed
26-Nov-17 27-02-18Closed
26-Nov-17 27-02-18Closed
26-Nov-17 27-02-18Closed
26-Nov-17 27-02-18Closed
26-Nov-17 27-02-18Closed
26-Nov-17 27-02-18Closed
1-Jan-18  Open
1-Jan-18 20-03-18Closed
8-Oct-17 21-03-18Closed
28-Dec-17 21-03-18Closed
28-Dec-17 21-03-18Closed
16-Nov-17 21-03-18Closed
16-Nov-17 21-03-18Closed
29-Oct-17 27-02-18Closed
9-Dec-17 19-02-18Closed

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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