Forum Discussion

binayjethwa's avatar
binayjethwa
Helper V
3 years ago
Solved

Show dates based on Hierarchy data

Hi, I have below requiement where i need to show start dates for different columns in a matrix , I have a matrix with Project and Stage title names , and i need to display individual dates for each...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi  binayjethwa ,

    I created some data:

    Project:

    Stage:

     

    Here are the steps you can follow：

    1. Create measure.

    Measure =
IF(
    ISINSCOPE('Stage'[title]),MAXX(FILTER(ALL(Stage),'Stage'[title]=MAX('Stage'[title])),[StartDate]),
    IF(       ISINSCOPE('Project'[title]),MAXX(FILTER(ALL(Project),'Project'[title]=MAX('Project'[title])),[Startdate]),BLANK()
))

    2. Result:

     

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi  binayjethwa ,

I created some data:

Project:

Stage:

 

Here are the steps you can follow：

1. Create measure.

Measure =
IF(
    ISINSCOPE('Stage'[title]),MAXX(FILTER(ALL(Stage),'Stage'[title]=MAX('Stage'[title])),[StartDate]),
    IF(       ISINSCOPE('Project'[title]),MAXX(FILTER(ALL(Project),'Project'[title]=MAX('Project'[title])),[Startdate]),BLANK()
))

2. Result:

 

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly