Finding and presenting week commencing of a date

Hello everyone,

Hope you may be able to help with this.

I am looking to update the version projection chart, so that the the projected date will show the Week Commencing rather than a specific date.

I have been using the calculated measures based on the Project Prediction Chart

I will then output this as text on a vertical line.

If anyone can help, I would greatly appreciate this.

Thanks,
Chris

Hi @ChrisF ,
You can change the measure formatting using Format() function:

--annotations.group=Predicted by issues
Case when
    DateInPeriod(
      [Measures].[Project predicted date],
      [Time].CurrentHierarchyMember)
   Then
     'Project Predicted date - ' 
    || Format([Measures].[Project predicted date], '"W"ww, yyyy')
End

See more examples in this community post (at the end):

best,
Gerda // support@eazybi.com