Folks, we are blessed to now have the famous Mr. Excel himself, Bill Jelen, contributing to the PowerPivot FAQ. He is our first hardcore Excel pro (other than myself, cough cough) on the moderators team, so we are clearly setting a high bar here 
Not only does he bring many years of Excel expertise (check out a selection of his books here on Amazon), but he also brings a certain flavor of dry wit that is quite refreshing. For example, here’s one of the many FAQ items he has already submitted:
Welcome Bill!
To see Bill’s many contributions to the FAQ so far, click here. To see the unfiltered FAQ, click here.
LOL!
Welcome to the FAQ Mr. Excel!! It’s an honor to me too!
Is there a Equivalent to the Excel’s ROW() function in DAX
No. Given the intentional lack of A1-style reference in PowerPivot, there is no equivalent to the ROW() function. What are you trying to achieve? Maybe there’s another way to do what you are attempting.
Well its a bit complex to explain.. and it would be best if I can somehow e-mail you the file… but I will try and explain in a few lines
I have an Employee Database and another Training Database(training attended by different emp. for last 3 years – some emp. might not have attended any trainings)
So I have the table below – and have to add a calculated column called counter which flags the 1st instance of an Emp ID in the year
Emp TrainingCode Date CTR
EMP001 TRG001 2007 1
EMP001 TRG002 2007 0
EMP002 TRG006 2007 1
EMP003 TRG010 2008 1
EMP001 TRG010 2008 1
EMP002 TRG001 2008 1
EMP001 TRG004 2008 0
EMP002 TRG003 2008 0
Its huge data (in Access DB) and currently achive this through SQL but its slow
So is there something in DAX…it would be a great help
Hi Sam. I replied in email. If/when we figure something out, I’ll post the answer here.