Create a custom field using Project dimension

Questions & Answers
1

I would like to create a calculated field using Project dimension.

Example:
Project Name Value
AA XXX 3
AA XYZ 4
AA ZYZ 5
BB XXX 2
BB CBA 3
BB MNC 2

Desired Output:

IF Poject name STARTSWITH (“AA”) THEN “Alpha”
IF Poject name STARTSWITH(Project,“BB”) THEN “Beta”

Project Name Value
Alpha 12
Beta 7

Can any one please help me on this issue.

Thanks,
Siva

2

Hi @scherukula,
There are several ways on how you can do this.

  1. You can rename the Project members to have them displayed as different names,
    rename_project_names
    Another_name

  2. Or create an aggregate in Project dimension if there are several members, use regular expression to find projects that start with certain parameter:

Aggregate(
  Filter(
    [Project].[Project].Members,
    [Project].CurrentMember.Name MATCHES "^DEMO.*"
  )
)

image
image1062×548 34.8 KB

  1. Also you can add an additional measure that would have another name displayed for each project:

CASE WHEN [Project].CurrentHierarchyMember.Name = "Demo" THEN "New name" WHEN [Project].CurrentHierarchyMember.Name = "DEMO Alfa" THEN "Alpha" WHEN [Project].CurrentHierarchyMember.Name = "DEMO Beta" THEN "Beta" END

case_when

best,
Gerda // support@eazyBI.com