Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

DAX code to create a NextGoLive field

Our project plans can have either a one-off “big-bang” or multiple staged go-lives and we need to create a field that can determine which is the next go-live date within a project. I have fields, in the MSProject Tasks table, that can assist, as follows, Project Name – multiple entries Task Name – multiple entries per project TaskFinishDate – date field per task MilestoneType – set to “Go Live” but can be one or many per project MilestoneStatus – Column, set to 1 to indicate a future dated milestone The selected Milestone (TaskName) needs to obey the following rules TaskIsMilestone=True TaskIsExternal=False Thanks and regards Fred

Need Help

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi v-lili6-msft , I have placed an Excel extract of sample data here .  This represents a variety of different MilestoneType and MilestoneStatus values.  All fields come from the Tasks MSProject table.  As you will see, there are multiple entries for each project.  There is also a Projects table, which contains a single entry for each project.

      The result would be, either

      - a field on each Task entry, which shows the NextGoLiveDate for that project, i.e. all Tasks would have the same value

      or

      - a field on each Project entry in the Projects table, indicating what the NextGoLiveDate is.

       

      Thanks in advance for any help you can provide.

      Regards

      Fred

      • v-lili6-msft's avatar
        v-lili6-msft
        Community Support
        6 years ago

        hi  Anonymous 

        Could you please give the expected output by these sample data(Use a example in this example) that will be a great help.

         

        Regards,

        Lin