Cumulative Count

[Jamie_Hughes]

Hi,

I am new to Power BI and DAX and I was wondering if someone could help me.

I have a table with duplicated names in a column, I would like a DAX formula to count the amount of times it see's a name.

For instance if Jamie were to appear 3 times, I would like it to show

Name  Instance

Jamie    1

Jamie    2

Jamie    3

Your help and time is greatly appriciated 

[Zubair_Muhammad · Accepted solution]

Hi @Jamie_Hughes

To do this in DAX..you will need to add an Index Column from the Query Editor first.

Then you can use this Calculated Column

Instance_ =
RANKX ( FILTER ( Table1, [Name] = EARLIER ( [Name] ) ), [Index],, ASC, DENSE )

[Jamie_Hughes]

Hi @Zubair_Muhammad,

Thank you, exactly what I needed 🙂