add column based on another column

[WardJ]

I've serarched for an answer to this but being new to Power BI i've really struggled to try find a solution I can translate to my own needs.

I have a table with a list of ID's and date of entry:

Source Data

I am trying to add a column showing the order they entered like this:

Output Data

Any assistance will be greatly appreciated.

[Ashish_Mathur · Accepted solution]

Hi,

Try this calculated column formula

=CALCULATE(COUNTROWS(Data),FILTER(Data,Data[ID]=EARLIER(Data[ID])&&Data[Date Entered]<=EARLIER(Data[Date Entered])))

The result should be 1,1,2,3,2,4,1

[WardJ]

Thank you @Ashish_Mathur that works perfectly 🙂

[Ashish_Mathur]

You are welcome.