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.

I already have a measure called "Revenue". I would also like to have the same calculation for the upcoming week, which is in the future, starting from Monday to Sunday.

 

Hope you can help me.

Thank you.

Need Help

2 Replies

  • 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?