How to add a dynamic column that adds the times a value appears?

[Syndicate_Admin]

Hello I have a problem!

I have a base that contains a mail variable and I need that as the mail is repeated, the variable tells me what number of repeats it is, for example:

Either with DAX and with Query Transform. Thank you very much forum!

[Bifinity_75 · Accepted solution]

Hi @Syndicate_Admin , try this:

- Insert a column Index in Power Query

- Create a this calculate column:

Vez repetida = 
CALCULATE (
    COUNT (Tabla[Correo] ),
    FILTER (
        ALL(Tabla),
        Tabla[Índice]<= EARLIER ( Tabla[Índice])
            && Tabla[Correo]= EARLIER ( Tabla[Correo])
    )
)

- The result:

Best regards

[Syndicate_Admin]

Thank you very much brother!!! Do not invent had stuck for a long time, it worked perfectly, only instead of sorting by Index I did it with a date 🙂 variable Greetings!