DAX Formula for Cumulative and %Cumulative

melq64

New Member
Joined
Aug 21, 2017
Messages
48
Hi,

I have the following dax formulas for my cumulative total and % cumulative. Its working but not showing the correct cumulative in the technical sense

Total Items Delivered:
TotalItemsDelivered:=CALCULATE(COUNTROWS('DistProfile v1-3'),FILTER('DistProfile v1-3','DistProfile v1-3'[DeliveryDate]<>BLANK()))

Cumulative Total Items Delivered:
CumulativeTotalDelivered:=IF(MIN(dCalenderDelivery[Date])>CALCULATE(MAX('DistProfile v1-3'[DeliveryDate]),ALL('DistProfile v1-3')),BLANK(),CALCULATE(COUNTROWS('DistProfile v1-3'),FILTER(ALL(dCalenderDelivery),dCalenderDelivery[Date]<=MAX(dCalenderDelivery[Date]))))


%Cumulative Total Items Delivered:
%CumulativeTotalDelivered:=DIVIDE([CumulativeTotalDelivered],CALCULATE([CumulativeTotalDelivered],ALLSELECTED('DistProfile v1-3'[Delivery Days])))


Here is screenshot of the output pivot table based on the above % Cumulative formula:

https://drive.google.com/file/d/1weSOA0OxIu5QiC5WU_Q_TMK2DWZhhrnk/view?usp=sharing


Appreciate any help:)
 

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Forum statistics

Threads
1,089,299
Messages
5,407,447
Members
403,143
Latest member
CTremblay

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top