Calculate measure with multiple dates

Hi,

You may download my PBI file from here.

Hope this helps.

Hey Anonymous ,

next to the solution provided by Ashish_Mathur , here is another approach that only makes use of the tables

• Revision Table
• Calendar

Tom = 
var MAXSelectedDate = MAX('Calendar'[Date] )
var SelectedYear = YEAR( MAXSelectedDate )
var SelectedMonth = MONTH( MAXSelectedDate )
var EoMofSelectedDate = EOMONTH( MAXSelectedDate , 0 )
var __AllPurchDatesInSelectedMonth = DATESBETWEEN( 'Calendar'[Date] , DATE( SelectedYear , SelectedMonth , 1) , EoMofSelectedDate )
return
CALCULATE(
    SUM( 'Revision Table'[Quantity] )
    , 'Revision Table'[Purch Date] IN  __AllPurchDatesInSelectedMonth
)

A little screenshot:

Hopefully, this provides what you are looking for.

Regards,

Tom