Forum Discussion

tristanweeks47's avatar
tristanweeks47
Frequent Visitor
3 years ago
Solved

Weekly Data Format

Hello,  So i have had a project where they want to see sales report based on the last 8 weeks and the week to start on Monday. Managed this no issue, however i can't remove the format 00:00:00 from ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi tristanweeks47 ,

    Please update the formula of calculated column [WeekStartDate] and update the date type as "Date":

    WeekStartDate =
DATEADD (
    opportunity[Created On].[Date],
    -1 * WEEKDAY ( opportunity[Created On].[Date], 2 ),
    DAY
)

    Best Regards

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi tristanweeks47 ,

Please update the formula of calculated column [WeekStartDate] and update the date type as "Date":

WeekStartDate =
DATEADD (
    opportunity[Created On].[Date],
    -1 * WEEKDAY ( opportunity[Created On].[Date], 2 ),
    DAY
)

Best Regards