Forum Discussion
Removing Time stamp from date
I have a formula "Week of Due Date = "Week of" & " " & 'BAH Task Tracker'[Due Date] - WEEKDAY('BAH Task Tracker'[Due Date],2) + 1" that returns the first day of each week after the words "Week Of...
Hi Anonymous ,
Please try the following methods and check if they can solve your problem:
1.Ensure that the date part is considered, removing the time component.
2.Try the following DAX formula.
Week of Due Date = "Week of" & " " & FORMAT('BAH Task Tracker'[Due Date] - WEEKDAY('BAH Task Tracker'[Due Date],2) + 1, "dd/mm/yyyy")Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This solved my issue! Thank you so much!
Hi Anonymous ,
Please try the following methods and check if they can solve your problem:
1.Ensure that the date part is considered, removing the time component.
2.Try the following DAX formula.
Week of Due Date = "Week of" & " " & FORMAT('BAH Task Tracker'[Due Date] - WEEKDAY('BAH Task Tracker'[Due Date],2) + 1, "dd/mm/yyyy")
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This solved my issue! Thank you so much!