Forum Discussion

zrichardson's avatar
zrichardson
Advocate III
9 years ago
Solved

First Date in Group

I have a table with branches and File Start Dates. We don't currently have a branch started date in our database so I was going to use the earliest file start date as the branch start date. This woul...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi zrichardson,

     

    To resolve your issue, you should combine the column [BranchID] and [FileStartedDate] into a single table, as is shown in your original post. If you have had a table contains column [BranchID], please create a calculated column like:

    FileStartDate = RELATED(MilestoneDates[FileStartDate])

    Then, you can use below DAX formula to display the earliest file start date.

    BranchStartDate = Calculate(Min(Table[FileStartedDate]), Filter(Table, Table[BranchID]=Earlier([BranchID])))

    Best regards,
    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi zrichardson,

 

To resolve your issue, you should combine the column [BranchID] and [FileStartedDate] into a single table, as is shown in your original post. If you have had a table contains column [BranchID], please create a calculated column like:

FileStartDate = RELATED(MilestoneDates[FileStartDate])

Then, you can use below DAX formula to display the earliest file start date.

BranchStartDate = Calculate(Min(Table[FileStartedDate]), Filter(Table, Table[BranchID]=Earlier([BranchID])))

Best regards,
Yuliana Gu