Filter dates problem

Analitika — Mon, 14 Dec 2020 11:14:53 GMT

I tryng to filter dates from APV until min date selected by slicer

but this measure return always empty

CALCULATE (

[Suma]

,FILTER ( _APV[DATE] ),

_APV[DATE] < MIN ( 'Date'[Date] )

)

CALCULATE (

[Suma]

,FILTER ( ALL(Date[DATE]) ),

Date[DATE] < MIN ( 'Date'[Date] )

)

return wrong values as table APV min date is 2009.01.01 but date slicer generated limited Now()-3 to reduce data and make PBI loading data

Date = CALENDAR (

DATE ( YEAR(NOW())-3, 1, 1),

DATE ( YEAR(NOW()), 12, 31)

)

Re: Filter dates problem

lbendlin — Tue, 22 Dec 2020 14:35:44 GMT

Please provide sample data in usable format and show expected outcome.