Rename the displayed date field

Questions & Answers
1

Can I change the name of this field?

ex: I want to display only the month and erase the 2025.

image
image732×440 28.1 KB

2

ey! I think, not directly but creating a Measure for it.
Going into Time Dimension and creating a new calculated member like:


Aggregate({
  FORMAT([Time].[Year].CurrentDateMember.StartDate, "MMMM")
})

or whatever you want to use. And it would display only the name

1 Like
3

@henrique.ribeiro

You could consider creating calculated members with Aggregates in “Time” dimension

See few examples.

example
example1924×1648 397 KB

See code examples below:

Jan

Aggregate(
Filter(
  [Time].[Month].Members,
  Cast([Time].CurrentHierarchyMember.key as numeric) = 1
  )
)

Feb

Aggregate(
Filter(
  [Time].[Month].Members,
  Cast([Time].CurrentHierarchyMember.key as numeric) = 2
  AND
  Cast([Time].CurrentHierarchyMember.Parent.Parent.key as numeric) = 2025
  )
)

Mar

Aggregate(
Filter(
  [Time].[Month].Members,
  Cast([Time].CurrentHierarchyMember.key as numeric) = 2
  AND
  Cast([Time].CurrentHierarchyMember.Parent.Parent.key as numeric) >= 2023
  )
)

Apr

Aggregate(
  {
  [Time].[2025].[Q2 2025].[Apr 2025],
  [Time].[2024].[Q2 2024].[Apr 2024]
  }
)

Martins / eazyBI

1 Like