topic Re: Return first and last day of the week. in DAX Commands and Tips

Return first and last day of the week.

hugo_barbara — Wed, 22 Jun 2022 19:09:01 GMT

Guys, I need to put two dates in a measure, the first day of the week and the last day, and it will pull from the filter of the current week. I tried some DAX code but no success. Here's what I tried to do:

var firstDayWeek = calculate(MIN(dCalendario[Coluna]),dCalendario[Semana do Ano] = [Semana Atual])

var lastDayWeek = calculate(MAX(dCalendario[Coluna]),dCalendario[Semana do Ano] = [Semana Atual])

return

firstDayWeek & lastDayWeek

Re: Return first and last day of the week.

WinterMist — Wed, 22 Jun 2022 21:32:13 GMT

Hello hugo_barbara

Check out this blog (& video).

Let me know if this is helpful to you.

https://bielite.com/blog/week-start-date-power-bi-dax/

Regards,

Nathan

Re: Return first and last day of the week.

hugo_barbara — Thu, 23 Jun 2022 11:48:02 GMT

Tks Nathan,

Everything worked!!

Re: Return first and last day of the week.

WinterMist — Thu, 23 Jun 2022 14:02:10 GMT

Very good! You are welcome.