Forum Discussion
Removing Time stamp from date
I have a formula
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.
4 Replies
Anonymous
in powr query, change datatype yo date instead of datetime .
if you need the time, in other reports, then create a duplication of this column, and leave it as datetime,
and the original one you can change its datatype to date .
hope this helps .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠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.
