Forum Discussion
Filter data using date range from slicer
- 8 years ago
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.
Regards,
Daniel He
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.
Regards,
Daniel He
v-danhe-msft this worked, thank you so much!