Forum Discussion

daxnoob's avatar
daxnoob
Frequent Visitor
3 years ago
Solved

Include the min Date in Summarize

Hi, Is it possible to include the distinct min date value in a summarize measure? Here is my code: Countx(          Summarize(                  'Table',                  'Table'[Name],     ...
Need Help
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    Is this what you are looking for?

     

     

    Countx( FILTER(
         Summarize(
                 'Table',
                 'Table'[Name],
                 'Table'[Date])
                 'Table'[Age]),'Table'[Date]=min('Table'[Date])),
         [Measure]
)
----------
or
Countx( FILTER(
         Summarize(
                 'Table',
                 'Table'[Name],
                 'Table'[Date])
                 'Table'[Age]),'Table'[Date]=STARTOFMONTH('Table'[Date],0)),
         [Measure]
)

     

     

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
3 years ago

Is this what you are looking for?

 

 

Countx( FILTER(
         Summarize(
                 'Table',
                 'Table'[Name],
                 'Table'[Date])
                 'Table'[Age]),'Table'[Date]=min('Table'[Date])),
         [Measure]
)
----------
or
Countx( FILTER(
         Summarize(
                 'Table',
                 'Table'[Name],
                 'Table'[Date])
                 'Table'[Age]),'Table'[Date]=STARTOFMONTH('Table'[Date],0)),
         [Measure]
)