How to get weekdays from a certain date?

[rbalza]

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

[amitchandak · Accepted 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