Forum Discussion

MarkMahon's avatar
MarkMahon
Regular Visitor
3 years ago
Solved

Power Pivot in Excel - add Calculated Column to table that uses other rows in the Table - error

We created a table using Power Query in Excel. We added the table to the Data Model. We want to add a column that averages the subscriptions in the current month (=current record) with those in the...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    Hi MarkMahon ,

    I create a sample and after I click Add to Data Model in Excel>Power Pivot, and add a column by your formula, get the correct result.

    Haven't found the error you provided. I attach my sample below for your reference.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

MarkMahon's avatar
MarkMahon
Regular Visitor
3 years ago

Hi _kalyj - first of all, thank you for the reply.  

 

Second, with your help I got the formula to work for my application ... so thank you a second time.

 

The difference between your example (no error) and my work (error) is where the formula was placed ...

  • you set it up directly in the calculated column.
  • i set it up as a "measure" and then referenced it in the calculated column.

Best Regards,

Mark