Forum Discussion
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...
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) )
Lorenzo Thank you so much
Part 2 is fixed but In Queue seem like not outputting correct. I have 2 serial numbers for 24/10/2023 but only one is showing. I have used COUNTX not the top one.
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) )This works awesome
In Queue:=VAR minDate=MIN( 'Table'[Date] )
RETURN COUNTROWS( FILTER( 'Table', 'Table'[Date] = minDate) )But for this one I am getting 6,463 when Oldest Field is empty.
Thanks SergeiBaklan I combined your formula with Lorenzo and its working perfectly fine.
=IF(ISBLANK([Oldest Case]),BLANK(),INT( (TODAY() - MIN( 'Outstanding Reps'[Date] ) )/7 ) )Thank you
You are welcome, thank you for sharing