How to ignore the future date in Calculation

[CheanSereyvatan]

Hi beloved community team,
Recently, I'm facing 1 issue on 3 mobth distribution calculation method. All work well only issue on the future date that I don't want it to appear on the chart. Here is my calculation : 

Distribution Count = COUNTROWS(CALCULATETABLE(SUMMARIZE('IMS_Daily Sale','IMS_Daily Sale'[Customer ID]),'IMS_Daily Sale'[QtyWithoutDiscount]>0,DATESINPERIOD(DimDates[Date],Max(DimDates[Date]),-3,MONTH)))

Thanks for your kindly support.

Vatanak CK

[TomMartens · Accepted solution]

Hey @CheanSereyvatan ,

not sure what you mean by future dates, elaborate more on this.

This measure only contains the DATESINPERIOD part from yor measure:

theMaxDate = 

var theDates = DATESINPERIOD( 'DimDate'[Datekey] , MAX( 'DimDate'[Datekey] ) , -3 , MONTH )
RETURN
MAXX( theDates , 'DimDate'[Datekey] )

As you can see from the below visualizations

• the card visual shows the last day of the calendar table, because the last day of the calendar table is the 31st, December of 2011 (this is because I use an old Contoso Retail DW demo data set)
• the table visual with has the datekey from the calendar table on the rows and for this reason the calendar table is filtered accorcingly

It's necessary that you elaborate on "Future Dates" and also on the visual and what you want to achieve from a data visualization point of view and the date filter that you are applying inside your measure.

Regards,

Tom