Solved: Re: Week Filter

jiji · ‎06-06-2022

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?`

v-yalanwu-msft · ‎06-08-2022

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.

How to get your questions answered quickly -- How to provide sample data

View solution in original post

v-yalanwu-msft · ‎06-08-2022

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.

How to get your questions answered quickly -- How to provide sample data

DimaMD · ‎06-06-2022

Привіт @jiji , Try it

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

but the 23rd week of 2022 is June

__________________________________________

Thank you for your like and decision

__________________________________________

Greetings from Ukraine

To help me grow PayPal: embirddima@gmail.com