skip to Main Content

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:

PowerPivot with Dry Northeast Ohio Wit

Welcome Bill!

To see Bill’s many contributions to the FAQ so far, click [link removed due to 404] here.  To see the unfiltered FAQ, click [link removed due to 404] here.

Rob Collie

One of the original engineering leaders behind Power BI and Power Pivot during his 14-year career at Microsoft, Rob Collie founded a consulting company in 2013 that is 100% devoted to “the new way forward” made possible by Power BI and its related technologies. Since 2013, PowerPivotPro has rapidly grown to become the leading firm in the industry, pioneering an agile, results-first methodology never before seen in the Business Intelligence space. A sought-after public speaker and author of the #1-selling Power BI book, Rob and his team would like to help you revolutionize your business and your career.

This Post Has 5 Comments
    1. 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.

  1. 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

Leave a Comment or Question