topic Re: Current week's Tuesday date in DAX Commands and Tips

Current week's Tuesday date

Ashik008 — Mon, 24 Jun 2024 15:05:09 GMT

Hi all,

I need help with date column .

I have a date column which shows current date using Today() function . I need to create another column which showing the Tuesday' date of that week .

for example if today is 6/23/2024, column should show 6/25/2024 and it changes when next week starts

eg when6/30/2024 starts , new column changes to 7/2/2024 like that .please help.

Re: Current week's Tuesday date

Ashik008 — Mon, 24 Jun 2024 15:02:24 GMT

Hi all,

I need help with date column .

I have a date column which shows current date using Today() function . I need to create another column which showing the Tuesday' date of that week .

for example if today is 6/23/2024, column should show 6/25/2024 and it changes when next week starts

eg when6/30/2024 starts , new column changes to 7/2/2024 like that .please help

Re: Current week's Tuesday date

ajohnso2 — Mon, 24 Jun 2024 15:21:27 GMT

You really should look into having a date dimension if you dont already, this would be the easiest option.

For example, if you had a column holding the day of week number - you would basically have your answer

Re: Current week's Tuesday date

Anonymous — Tue, 25 Jun 2024 02:49:51 GMT

Hi,

Thanks for the solution ajohnso2 provided, and i want to offer some more infotmation for user to refer to.
hello Ashik008 , you can refer to the following code.

Based on the today column, create a new calculated column.

Column 2 = var a=WEEKDAY([Today],1) return [Today]-a+3

Output

And you can refer to the attachment

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.