Forum Discussion

azaterol's avatar
azaterol
Helper 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
Super 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
    Helper 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?