Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Selecting First Date and Time

I have a column of datetime data and I am trying to select the first date after filtering the table. I am using the following calculated column formula:   First Date = CALCULATE(FIRSTDATE('Table'[...
Need Help
  • Cmcmahan's avatar
    Cmcmahan
    7 years ago

    Can  you not just use MIN?

     

     CALCULATE(MIN('Table'[Date].[Date]), FILTER('Table', 'Table'[TestID] = 'Table2'[TestID]))

     

Cmcmahan's avatar
Cmcmahan
Resident Rockstar
7 years ago

Can  you not just use MIN?

 

 CALCULATE(MIN('Table'[Date].[Date]), FILTER('Table', 'Table'[TestID] = 'Table2'[TestID]))