Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

IF VALUE DUPLICATE

Hi Team   i need your help i have data , which is im willing to remark if within column there are same value will result same as table below   again, i also want to know how to remark but ...
Need Help
Show and Tell
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    Hi Anonymous ,

    Please try this:

    • Get an index column in Query Editor

    • Create a calculated column
    Column = 
VAR a =
    RANKX (
        FILTER (
            'Table',
            'Table'[DATA] = EARLIER ( 'Table'[DATA] )
                && 'Table'[DATE] = EARLIER ( 'Table'[DATE] )
        ),
        'Table'[Index],
        ,
        ASC
    )
RETURN
    IF ( a > 1, "Yes", "No" )

    Best Regards,

    Xue Ding

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Ashish_Mathur 

 

just same like an excel

if value of table X in row 2 same with row 1 then  "YES","NO"

 

how to make it in DAX

 

thanks

syaiful

v-xuding-msft's avatar
v-xuding-msft
Community Support
6 years ago

Hi Anonymous ,

Please try this:

  • Get an index column in Query Editor

  • Create a calculated column
Column = 
VAR a =
    RANKX (
        FILTER (
            'Table',
            'Table'[DATA] = EARLIER ( 'Table'[DATA] )
                && 'Table'[DATE] = EARLIER ( 'Table'[DATE] )
        ),
        'Table'[Index],
        ,
        ASC
    )
RETURN
    IF ( a > 1, "Yes", "No" )

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.