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 suggestions on what dax I should use here? 

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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")

  • 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 .