topic Re: Creating running total when table values are dates instead of numbers in Custom Visuals Development Discussion

Creating running total when table values are dates instead of numbers

ABhatt22 — Thu, 02 Dec 2021 10:31:49 GMT

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

Hi,

I have the following sample table as my data input:

Order ID	City	Customer	Order Date	Step 1	Step 2	Step 3	Step 4
2	New York	ABC	25/12/2020	12/1/2021	18/1/2021	30/1/2021
4	San Francisco	ABC	15/1/2021	27/1/2021	29/2/2021
10	Los angeles	XYZ	25/2/2021	19/3/2021	20/4/2021	22/4/2021	29/4/2021
17	Dallas	XYZ	27/3/2021	25/4/2021
35	Dallas	XYZ	19/4/2021	20/5/2021	21/6/2021	28/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.

This figure for December should be 245.

Can someone please help?

@amitchandak @AlexisOlson

Re: Creating running total when table values are dates instead of numbers

AlexisOlson — Thu, 02 Dec 2021 16:00:51 GMT

Are you summing your Order IDs instead of counting them?

Re: Creating running total when table values are dates instead of numbers

ABhatt22 — Thu, 02 Dec 2021 16:05:55 GMT

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