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.
           
    )
Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

See if this measure works

Quantity shipped YTD = calculate([quantity shipped],datesbetween(calendar[date],minx(allselected(),Calendar[Date]),max(calendar[date])))
sabd80's avatar
sabd80
Helper IV
3 years ago

there is something wrong with syntax inside minx.