SUMMARIZE DAX With Selected Date

[admin_xlsior]

Hi guys,

Can we use SUMMARIZECOLUMN (or SUMMARIZE) by filtering it based on the Date selected from the slicer ?

So I have this transaction (MyTrans):

INVOICEDATE	PARTNO	AMOUNT
1/1/1900	P-100092	0
1/9/2015	P-100028	45200
1/9/2015	P-100029	45200
2/8/2016	P-100249	45200
2/8/2016	P-100250	45650
2/8/2016	P-100251	45650
2/8/2016	P-100250	47050
2/8/2016	P-100253	47050
2/8/2016	P-100259	51250
3/14/2016	P-100250	28500
3/14/2016	P-100360	29900
3/17/2016	P-100260	45200
3/17/2016	P-100261	46850

And I would like to group it based on INVOICEDATE, usually I would only do SUMMARIZE like :

SUMMARIZE(MyTrans, InvoiceDate. SUM(Amount) 

But I have a slicer Date, which someone will put a date, and the SUMMARIZE will need to filter only up to that selected date.

For some reason I cannot create relationship between my transaction table to Date dimension, so I need to filter that in that SUMMARIZE function.

My measure to capture the date is "SelectDate = SELECTEDVALUE(DimDate[Date])

When I create the summary using :

SUMMARIZE (

FILTER(MyTrans, MyTrans[InvoiceDate]<=[SelectDate]),

MyTrans[INVOICEDATE].

"Amount", SUM(MyTrans[AMOUNT])

)

or 

SUMMARIZECOLUMN(

MyTrans[INVOICEDATE), 

FILTER(MyTrans, MyTrans[InvoiceDate]<=[SelectDate]),

"Amount", SUM(MyTrans[AMOUNT])

)

Both of them returns no records. If I checked the measure, using Card, it did captured the date selected.

Thanks,

[amitchandak]

Can you try in the selected date 

max(DimDate[Date])

maxx(DimDate,DimDate[Date])

\Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.