Calculate volume for max month

[NewbieJono]

is there any method to calculate the total volume for the whole month based on the last date in a table

e.g

if the data for april went up to 27th April. i would like to calculate the volume for all dates in april.

[Ritaf1983 · Accepted solution]

Hi @NewbieJono 
You can use something like :

last month sales =

VAR

max_Date =

CALCULATE(MAX('orders'[Order Date]),REMOVEFILTERS('Calendar'))

RETURN

CALCULATE([total_sales],YEAR('Calendar'[Date])= year(max_Date) && month('Calendar'[Date])= month(max_Date))

the pbix is attached 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[Alex87]

Hello @NewbieJono ,

Please try the following DAX measure:

TotalVolumeForMonth = 

VAR _LastDateInMonth = MAX('Table'[Date])  // Assuming 'Date' is your date column and it is properly formatted as a date.
VAR _StartOfMonth = STARTOFMONTH('Table'[Date])
VAR _Result = 
CALCULATE(
    SUM('Table'[Volume]),  
    'Table'[Date] >= _StartOfMonth && 'Table'[Date] <= _LastDateInMonth
)
RETURN
_Result

 If it satisfies your needs, please do not forget to mark my reply as the solution. Cheers!