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 x axis label without it then saying previous day (Sunday), instead of Monday. Any help would be greatly appreciatted. 

 

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

1 Reply

  • 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