Finding and presenting week commencing of a date

[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