Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Folks,
Been wondering how to do this task. Say I have a date that starts from 11.Apr.2021, and I have Weekdays as a header.
Now, I want to automatically calculate the previous week based on the start date/timesheet date as per below table. So the table on weekdays would be backdated for a week. Appreciated your help on this one.
Timesheet Date | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
11-Apr-21 | 4-Apr | 5-Apr | 6-Apr | 7-Apr | 8-Apr | 9-Apr | 10-Apr |
Solved! Go to Solution.
@rbalza , Previous weekday is 7 day behind , with help from date table
7 behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-7,DAy))
If they fixed week, first create a week in your date tbale
Any Weekday Week - Start From Any day of Week
https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Powe...
Then use these blog for WOW
Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8
@rbalza , Previous weekday is 7 day behind , with help from date table
7 behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-7,DAy))
If they fixed week, first create a week in your date tbale
Any Weekday Week - Start From Any day of Week
https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Powe...
Then use these blog for WOW
Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8
User | Count |
---|---|
41 | |
27 | |
23 | |
19 | |
16 |
User | Count |
---|---|
54 | |
35 | |
19 | |
19 | |
15 |