Forum Discussion

azaterol's avatar
azaterol
Icon for Helper V rankHelper V
2 years ago

Automatic Calculated Weeks

Hello everyone, I would like to have the revenue for the current week displayed. If today is Wednesday, it should still be calculated from the beginning of the week, starting from Monday to Sunday. ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

azaterol , You can use a measure like

 


This Week Today =
var _min = today() -WEEKDAY(today() ,2) +1 //Monday week start
var _max = _min +6
return CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

 

Last Week Today =
var _min = today() -WEEKDAY(today() ,2) -6 //Monday week start
var _max = _min +6
return CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

azaterol's avatar
azaterol
Icon for Helper V rankHelper V
2 years ago

Thank You amitchandak ,

 

2 2uestions I have in your Code:

Why are you adding +1 at the end of _min?


This Week Today =
var _min = today() -WEEKDAY(today() ,2) +1 //Monday week start
var _max = _min +6
return CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

 

The code also works without the +1.

 

Second question is:

If I want the calculation 2 weeks ago. Do I then subtract at _min - 12 at the end? If I do this, I end up when I calculate back 12 days, I start from today (Tuesday) and end up with Wednesday 03/13/24. But why does he calculate from Monday 03/11/24? Can you explain that to me?