Return first and last day of the week.

[hugo_barbara]

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

[hugo_barbara]

Tks Nathan, 

Everything worked!!

[WinterMist]

Very good!  You are welcome.

[WinterMist · Accepted solution]

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