Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Help with Dax code

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 suggesti...
Need Help
vojtechsima's avatar
vojtechsima
Super User
4 years ago

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 .