cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mbailey
Helper II
Helper II

How to count number of days within date range of Date Sliver?

Hi,

I need to build a calculation that counts the number of items within a given date range - using a Date, Between Slicer on a Date table, and then I need to divide the number of days in that date range of the slicer by the number of Items in that date range.

 

So, for example: If my date slicer shows 07/15/2021 - 09/16/2021 (63 days) and there are 45 items during that time period, I want to divide 63/45.  If the date slicer was then changed to 09/01/2021 - 09/16/2021, (16 days) and there were 23 items, I want to divide 16/23.

 

Is this possible?

 

Thanks for your help!

Mike

1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

@mbailey 

you need to create a date table and create relationship with the current table.

Then create a measure.

Measure = COUNT('Date'[Date])/sum('Item'[Item])

 1.PNG

pls see the attachment below





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

1 REPLY 1
ryan_mayu
Super User
Super User

@mbailey 

you need to create a date table and create relationship with the current table.

Then create a measure.

Measure = COUNT('Date'[Date])/sum('Item'[Item])

 1.PNG

pls see the attachment below





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!