How do I create a week to date Tableau calculation with a Monday week start

Question

I am working on a project which shows several weeks of sales, Suppose we say today was Wednesday and weeks would be displayed as Monday, Tuesday, and Wednesday and I have changed week start in data source by using the formula:

 IF Datepart('weekday', [Date])<=DATEPART('weekday', TODAY()) THEN [Revenue] END

How can I change this formula for a week to start on Monday the above formula week starts on Sunday

Answer 1

Modify the calculation part like this:

IF DATEPART('weekday', TODAY()) = 1 THEN [Revenue] ELSEIF Datepart('weekday', [Date])>1 AND Datepart('weekday', [Date])<=DATEPART('weekday', TODAY()) THEN [Revenue] EN

If you want to learn more about it Tableau, then go through this Tableau Training for more insights.