Count of all previous dates

[Anonymous]

Hi,
I have a records based on date fields and i taken a slicer for the date field 
Suppose if I select date range from  01 Mar 2019 to 31 Dec 2019, I need a count of previous date range i.e.,  01 Mar 2019 to 01 Mar 2000

Here I consider that my database have the records from 01 Mar 2000 to 31 Dec 2019 and data is dynamic

Thanks in advance 

[Greg_Deckler]

Perhaps:

Measure =
  VAR __MinDate = MIN('Table'[Date])
RETURN
  COUNTROWS(
    FILTER(
      ALL('Table'),
      [Date] <= __MinDate
    )
  )

[Mariusz]

Hi @Anonymous 

Try something like 

Measure = 
VAR __min = MIN( 'Calendar'[Date] )
RETURN 
CALCULATE(
    COUNTROWS( 'Calendar' ),
    ALL( 'Calendar' ),
    'Calendar'[Date] < __min
)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[amitchandak]

@Anonymous 

What are the previous date, seems like an overlapping date. If you need year behind data , you can use with date calendar

Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))

Or you same duration last period

Last period =
var _min = minx(ALLSELECTED('Date'),('Date'[Date]))
var _max = maxx(ALLSELECTED('Date'),('Date'[Date]))
var _diff = DATEDIFF(_min,_max,DAY)+1
var _minx = _min-_diff
var _maxx = _max -_diff
Return
CALCULATE(SUM(Sales[Sales Amount]),filter(ALL('Date'),'Date'[Date]>=_minx && 'Date'[Date<=_maxx))

[Anonymous]

Hi @amitchandak ,

I tried the DAX working super But it is getting a year earlier data but I need all years data 

Example : 01 Jan 2000 to 16 Mar 2020 is a range of records in dataset

and I selected a range between 01 Mar 2020 to 16 Mar 2020 then i need a records before 01 Mar 2020 (i.e., from 01 Jan 2000 to 29 Feb 2020)

Thank you Amit for the great response in a less time 

Waiting for the reply 

[dax]

Hi @Anonymous , 

You also could refer to my sample for details.

Best Regards,
Zoe Zhi

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

[amitchandak · Accepted solution]

@Anonymous 

You need

Last period =
var _min = minx(ALLSELECTED('Date'),('Date'[Date]))

Return
CALCULATE(SUM(Sales[Sales Amount]),filter(ALL('Date'),'Date'[Date]<=_min))