Filter data using date range from slicer

[Manar]

Hi ,

I am trying to filter submissions count by a range of dates enterd in slicer  (between)

For example if a user enter a range of date the table should show the count of submissions for that range of dates.

I created this formula, it works when I choose one date but not a range, any help

Current_Submission =

var  startdate= max(DimDate[Date])                        

var  enddate = min(DimDate[Date])                                                                                                                                              Return      

calculate(DISTINCTCOUNT(

Submisions[Submission Number]),

   Filter (Submisions,  Submisions[Submission Date]>= startdate      &&   Submisions[Submission Date] <= enddate                                                                )                                                                                                                                                                               )

[v-danhe-msft · Accepted solution]

Hi @Manar,

Based on my test, you could refer to below steps:

Sample data:

Create a measure:

Current_Submission =
var startdate= max(DimDate[Date])
var enddate = min(DimDate[Date]) Return
calculate(DISTINCTCOUNT(Submission[Number]),
Filter (ALL(Submission), Submission[Date]<= startdate&&Submission[Date]>= enddate))

Now you could see the result:

You can also download the PBIX file to have a view.

https://www.dropbox.com/s/t5zoiqxm1d6aqcx/Filter%20data%20using%20date%20range%20from%20slicer.pbix?...

Regards,

Daniel He

[Manar]

@v-danhe-msft  this worked,  thank you so much!

[Anonymous]

Current_Submission =

VAR startdate= MIN(DimDate[Date])                     

VAR enddate  = MAX(DimDate[Date])                                                                                                                       Return      

calculate(DISTINCTCOUNT(Submisions[Submission Number]),
		Filter (Submisions,Submisions[Submission Date]>= startdate &&
                                   Submisions[Submission Date]<= enddate  ) 
           )

Try this.

Thanks
Raj