Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
@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))
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?
User | Count |
---|---|
83 | |
70 | |
69 | |
66 | |
53 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |