topic Re: Week Filter in DAX Commands and Tips

Week Filter

jiji — Mon, 06 Jun 2022 12:22:02 GMT

Hi Guys - Could you please help me create a week filter that could describe the days of the selected week? Can that be done in Power BI?

I have date filters; Year, Months, & WeekOfYear, and my lead would like to see the days within the selected week num. Say, If We select 2022 May, week 23, we should be a able to see "May 29 - June 4" or "May 22 - May 28".

I could have just add a separate day filter but they want it within the week filter. Is it possible?`

Re: Week Filter

DimaMD — Mon, 06 Jun 2022 13:47:42 GMT

Привіт jiji , Try it

= " " MIN(data[dates]) і "-" MAX(data[dates])

but the 23rd week of 2022 is June

Re: Week Filter

v-yalanwu-msft — Thu, 09 Jun 2022 02:59:33 GMT

Hi, jiji ;

You could create a measure then add it into card.

Measure = CALCULATE(MIN('Table'[Date]),REMOVEFILTERS('Table'[Day],'Table'[Month])) & "-"&CALCULATE(MAX('Table'[Date]),REMOVEFILTERS('Table'[Day],'Table'[Month]))

The final output is shown below:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.