Finding and presenting week commencing of a date

[ChrisF]

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

[gerda.grantina]

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):

Measure formatting (markdown and custom)

In this article, I will show a few tips and tricks on how it is possible to format the measures. In eazyBI, there are two interesting ways on how to format measures to get a different appearance. First is our newest formatting option, Text->Markdown (available on Cloud and starting from the eazyBI version 6.1), and second is a Custom format with which you can change the formatting of the measure. [eazyBI_Markdown] Markdown You can use Markdown formatting to show a rich text (bold, italic) or…

best,
Gerda // support@eazybi.com