- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Current week's Tuesday date
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
05-21-2024 07:42 AM | |||
05-16-2024 04:01 AM | |||
06-18-2024 07:19 AM | |||
05-02-2024 08:04 AM | |||
07-21-2021 12:45 AM |
User | Count |
---|---|
21 | |
17 | |
12 | |
6 | |
5 |
User | Count |
---|---|
29 | |
25 | |
20 | |
13 | |
10 |