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

[Squalleh]

Hi !

I have a new problem, my boss wants me to count the number of monday/... during the last 30days... I've try a lot of things but I'm still in trouble with that because I've find solutions with a DateTable and I can't use that...

Is there anyone with an idea?

Thx 🙂

Sq'

[vanessafvg · Accepted solution]

@Squalleh  why can't you use a date table?  that would be the easier to to do

it would be a simple measure

https://www.mattmasson.com/2014/02/creating-a-date-dimension-with-a-power-query-script/

no of mondays in last 30 days  =

CALCULATE (
COUNTROWS ( date ),
FILTER (
date,
DATESBETWEEN ( date[date], DATEADD ( date[date], -30, DAY ), date[date] )
&& dayofweek = "monday"
)
)

[Squalleh]

@vanessafvgthank you for your answer!

Finaly my boss accept to let me add a date table... so.... Problem solved!

Have a nice day!

Sq'

[Cabeza78]

Hi,

Could you share how did you solved?

Thanks.

Mauricio