Forum Discussion
ABhatt22
4 years agoNew Member
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 ID City Customer Order Date Step 1 Step 2 Step 3 Step 4 2 New Yo...
ABhatt22
4 years agoNew Member
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