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.
Hi I am trying to get previous week item counts, I was able to get the counts however having difficulty to capture previous week start date and previous week end date(week start from Sunday). I am trying with below expression but both returning current week start and end dates. Please advise.
Last Week Start Date = Today()-Weekday(Today()-1)+1
Last week End Date = Today()-Weekday(Today()-1)+7
I am expecting the result 4/25/2021 - 5/1/2021
Appreciate for help.
Solved! Go to Solution.
Hi @Anonymous,
Try the following
Last Week Start Date = (Today()-WEEKDAY(TODAY())+1)-7
Last Week End Date = (Today()-WEEKDAY(TODAY())+1)-1
Thanks,
Proud to be a Super User!
Hi You can check the following formula
Proud to be a Super User!
Hi You can check the following formula
Proud to be a Super User!
Hi @Anonymous,
Try the following
Last Week Start Date = (Today()-WEEKDAY(TODAY())+1)-7
Last Week End Date = (Today()-WEEKDAY(TODAY())+1)-1
Thanks,
Proud to be a Super User!
User | Count |
---|---|
80 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
98 | |
89 | |
82 | |
61 |