Need Help--Custom Week Number of the Month

[kruthikav]

I have 3 date filters, Month, Week and Day. Week starts from Sunday to Saturday.

Requirement: When I select 5th week of June, I want dates to be displayed from 26th June to 2nd July. Because 5th week of June starts from 26th June to 2nd July (7days).

But it is displaying data from 26th to 30th (last day of the month).

How do we achieve this?

Currently using below formula to get Weeknumber of the month

Weeknumberof Month = 1+WEEKNUM(Calender[Date])-WEEKNUM(STARTOFMONTH(Calender[Date]))

[lg1551]

It sounds like you would need a custom column to count your weeks in the manner you are describing.