Forum Discussion

sabd80's avatar
sabd80
Helper IV
3 years ago
Solved

Running Total Per Month

Hi, I want to get running total per day and month, most of the measures have filter on date like below:   filter(all('Date'),'Date'[date] <=max('Date'[date])   but when I do that the running tot...
Need Help
  • sabd80's avatar
    sabd80
    3 years ago

    I found this below dax somewherelse and it is doing what it should:

    Testing Qty Shipped RT =
    CALCULATE([Quantity Shipped],
           FILTER(ALLSELECTED('Calendar - Requested Date'), 'Calendar - Requested Date'[Calendar Date]<= max('Calendar - Requested Date'[Calendar Date]))
     
    Thanks for everyone's help.
           
    )
sabd80's avatar
sabd80
Helper IV
3 years ago

grandtotal , I have tried that, it does not work for daily and monthly.

 

Testing Qty Shipped RT Month2 =
VAR SelectedDate =  max('Calendar - Requested Date'[Calendar Date])
VAR QtyShippedRT=
CALCULATE([Quantity Shipped],
        'Calendar - Requested Date'[Calendar Date]<= max('Calendar - Requested Date'[Calendar Date]), ALL('Calendar - Requested Date')
       
)
return
QtyShippedRT
 
grandtotal's avatar
grandtotal
Resolver III
3 years ago

can you post the definiton of [Quantity Shipped]?

  • sabd80's avatar
    sabd80
    Helper IV
    3 years ago
    Quantity Shipped = SUM('Sales Order Details'[Unit Quantity Shipped])