cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jmigner Visitor
Visitor

How to count the number of each day of week within a certain date range?

Hello!

 

I have a table which has the dat range for my database and the day-of-week for each date. In my report, I want a formula which counts the number of each day of the week (e.g. 5 Monday's in May 2017) based on the date filter applied. I have tried a few different count formulas and they have not been working. Any ideas?

 

Thanks,

Julia

1 ACCEPTED SOLUTION

Accepted Solutions
Super User IV
Super User IV

Re: How to count the number of each day of week within a certain date range?

Hi @jmigner

 

You could just do a COUNTROWS for your date table, and then when you select each month, it would then just count the number of days when you put the Day Name into a table?

 

Here is an example below.

 

A-PBI Community.png

 





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

Proud to be a Super User!






Power BI Blog

View solution in original post

1 REPLY 1
Super User IV
Super User IV

Re: How to count the number of each day of week within a certain date range?

Hi @jmigner

 

You could just do a COUNTROWS for your date table, and then when you select each month, it would then just count the number of days when you put the Day Name into a table?

 

Here is an example below.

 

A-PBI Community.png

 





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

Proud to be a Super User!






Power BI Blog

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors