In power pivot, I have a table that contains CY LBS and PY LBS....in Power Pivot if I add the calculation of CY LBS minus PY LBS, it returns the correct figure...if I want to find the percent difference (CY LBS / PY LBS)-1 it does not return the proper percentage. Is there a different way I have to structure the formula for this to work?
If you have it divide the smaller number by the larger one then multiply by 100, it will give you the correct answer.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Alas...that did not work...one of my co-workers told me that for it to work you need to put the formula at the bottom of the power pivot column...that does not work in my example because it is a table linked to Access. I don't know where to go from here.
Sorry, with Access and Power Pivot(?) involved, I'm pretty much at a loss too.
Not quite.you need to put the formula at the bottom of the power pivot column
You can add a calculated column to Power Pivot and enter a formula that does a calculation based on other columns.
Only calculated fields (also called Measures) need to be placed in the grid below the table.
I don't quite understand why this would not work if the data source is an Access table. Once it shows in Power Pivot, you can add measures in the grid below the table.
Example.png
I have attached an image...not sure it is viewable....anyway...I can only click on the last cell of the data on the bottom...below that there are blank white cells and nothing happens if you try and click on them.
On the Power Pivot Home ribbon click the icon that toggles the visibility of the Calculation Area. It's on the very right in my version.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks