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.
           
    )
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])