Forum Discussion

mouzzampk's avatar
mouzzampk
Copper Contributor
Nov 15, 2023
Solved

DAX Count with MIN Date

Hi, I have Column A (Date) and Column B (Serial Number)   Date Serial 01/02/2019 EA12891803 02/02/2019 EA12891804 03/02/2019 EA12891805 04/02/2019 EA12891806 05/02/2019 EA12...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Nov 16, 2023

    mouzzampk 

    As variant for

    assuming no other filters

    Oldest Case:=MIN( 'Table'[Date] )

Weeks behind:=INT( (TODAY() - MIN( 'Table'[Date] ) )/7 )

In Queue:=VAR minDate=MIN( 'Table'[Date] )
RETURN COUNTROWS( FILTER( 'Table', 'Table'[Date] = minDate) )
mouzzampk's avatar
mouzzampk
Copper Contributor
Nov 16, 2023
Thank you so much for your help. Much appreciated.
Lorenzo's avatar
Lorenzo
Silver Contributor
Nov 16, 2023

mouzzampk Appreciate your feedback although my suggestions were obviously far too complex 😞

 

Regards

  • mouzzampk's avatar
    mouzzampk
    Copper Contributor
    Nov 16, 2023

    Lorenzo  because of you I learnt COUNTX and its so good to see such a positive community. 

     

    Thank you again and apologies for not properly publishing the template. 

     

    Best regards,

    mouzzampk

Resources