Help with Dax code

[Anonymous]

Hi all I am trying to write a dax code that looks down [flight_primary_document_number] for duplicates and then looks at [flight_date] to see if the duplicates have the same flight date. Any suggestions on what dax I should use here? 

[vojtechsima]

Hi, @Anonymous 
You can also use a measure like this:

IsDifferentDate = 
var currentNumber = SELECTEDVALUE(Flights[Number])
var summaryTable = CALCULATETABLE( SUMMARIZE( Flights, Flights[FlightDate]), REMOVEFIlTERS(Flights), Flights[Number] = currentNumber)
return IF ( COUNTROWS( summaryTable ) >= 2, "Yes",  "No")

Credit to @johnt75 .

[amitchandak]

@Anonymous , Not very clear

A new column like

New column =

var _cnt = count(filter(Table, [flight Number] =earlier([flight Number] ) && [Date] =earlier([Date] )  ), [flight Number])

return

if(_cnt>1, "Yes", "No")