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

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

Hi there, 

 

What are your two tables called and can you please post a small sample set of data showing the data as it is in the two columns.

 

We can definitely join them up for you and produce the results you need.  It's just helpful to see the tables & data as close to your actual structure.

 

:)

zrichardson's avatar
zrichardson
Advocate III
9 years ago

 

The Table 'Loans' contains the Branch ID, and 'MilestoneDates' contains Started Date.

 

Started Date is also linked to a calendar table.

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    9 years ago

    Have you considered creating a new table whcih is a merge of the two tables?  Then create your measure on that?

     

    This can be done in DAX but might be more efficient to do upstream.