Is there any workaround to get Relative Date Filter to work with ISO Weeks

[bilingual]

Hi, Is there any workaround to get Relative Date Filter to work with ISO Weeks instead of weeks and calender Weeks? - for a business product, i fail to understand why ISO weeks are not used.

[v-yanjiang-msft]

Hi @bilingual ,

Here are similar threads, hope it helps!

Issue with relative date filter being applied to iso-weeks

Relative date filter Last 52 Calendar Weeks gives ... - Microsoft Power BI Community

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@bilingual , Toy can create a formula based on today

Measure  this iso week=

var _min = minx(filter('Date', date[Date] =Today()), [ISO Week])

return

calculate([measure], filter('Date', date[ISO Week] =_min))