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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
ABhatt22
New Contributor

Creating running total when table values are dates instead of numbers

****PLEASE HELP, POWER BI NOOB this side****

 

Hi,

 

I have the following sample table as my data input:

 

Order IDCityCustomerOrder Date Step 1 Step 2Step 3Step 4
2New YorkABC25/12/202012/1/202118/1/202130/1/2021 
4San FranciscoABC15/1/202127/1/202129/2/2021  
10Los angelesXYZ25/2/202119/3/202120/4/202122/4/202129/4/2021
17DallasXYZ27/3/202125/4/2021   
35DallasXYZ19/4/202120/5/202121/6/202128/6/2021 

 

There are 4 steps for each order, and I want to see on a graph the overall running total and each month/week progress for order date and each step.  To this I want to add slicers for city and customer (both functioning together). 

 

I tried creating a calculated column but when I use that for a graph, it sums up all values and gives me a huge number (In picture below). Plus I am not able to add slicers to this. 

 

ABhatt22_1-1638440777022.png

 

This figure for December should be 245.

 

Can someone please help? 

 

@amitchandak @AlexisOlson 

2 REPLIES 2
AlexisOlson
Esteemed Contributor III

Are you summing your Order IDs instead of counting them?

ABhatt22
New Contributor

No, I created a new table with the 1st column with all the dates for this year and then a calculated column which calculates no. of orders undergoing each step before each cell value(dates) in the 1st column. And it does calculate it correctly but when I use that on a chart, it automatically sums up the values. Plus, I cant add slicers to that. 

This visual is named total orders but it is the no. of orders undergoing step 1  for each month. The actual no. is not 11k but 245

Helpful resources

Announcements
Top Kudoed Authors
Users online (5,086)