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

Could this work?

 

BranchStartDate = Calculate(
               FIRSTDATE('Table'[FileStartedDate]), 
                
                Filter(all('Table'), 'Table'[BranchID]=EARLIER('Table'[BranchID])))
  • zrichardson's avatar
    zrichardson
    Advocate III
    9 years ago

    I tried that, but I am still getting a circular dependency on the file start date.

    • 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 two tables are 'Loans' which contains the Branch ID, and MilestoneDates which has the started date. They are Linked with the relationship below.

         

         Started Date is also inactively linked to a calendar table.