Forum Discussion

Viola's avatar
Viola
Frequent Visitor
8 years ago
Solved

IF AND dax Formula

 

Hello i have tried all possible options, can anyone help here ? 

I am trying to CREATE NEW COLUMN, where if column N3 has duplicate in N2, returns 0, if no duplicated then return value from column I3.

I will highly appreciate your help. I am not trying to delete the duplicates i only need to to display 0 if duplicate. 

 

Thank yo so much in advance, i have already few hours gone on searching the answer on that. 

 

 

Viola

Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    Viola,

     

    You may follow the steps below.

    1) add an index column in Query Editor

    2) add a calculated column in DAX

    Column =
IF (
    RANKX (
        FILTER ( Table1, Table1[WO_no.] = EARLIER ( Table1[WO_no.] ) ),
        Table1[Index],
        ,
        ASC
    )
        = 1,
    Table1[Duration_hour],
    0
)

1 Reply

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    8 years ago

    Viola,

     

    You may follow the steps below.

    1) add an index column in Query Editor

    2) add a calculated column in DAX

    Column =
IF (
    RANKX (
        FILTER ( Table1, Table1[WO_no.] = EARLIER ( Table1[WO_no.] ) ),
        Table1[Index],
        ,
        ASC
    )
        = 1,
    Table1[Duration_hour],
    0
)