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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

April Fabric Community Update

Fabric Community Update - April 2024

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

March 2024 PBI Gallery Image

Power BI Monthly Update - March 2024

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