illusionek
Board Regular
- Joined
- Jun 21, 2014
- Messages
- 104
Hello!!!
I got a fairly complicated Stock Cover calculation in Excel that I am trying to replicate in PowerPivot. Unfortunately this calculation in regular Excel uses a combination of Offset and Match to get right values. I was doing some reading online and apparently this can be replicated in PP using Calculate and Filter but so far I was unable to replicate my specific scenario.
I was wondering if anyone could help me out.
I attached a sample Excel file with offset + match functions to show how it is currently done. I have also attached an example of PowerPivot with the same data in normalized tables where I am trying to reflect this calculation.
Please help
http://www.filedropper.com/excel-samplefile
http://www.filedropper.com/powerpivot-examplefile
I got a fairly complicated Stock Cover calculation in Excel that I am trying to replicate in PowerPivot. Unfortunately this calculation in regular Excel uses a combination of Offset and Match to get right values. I was doing some reading online and apparently this can be replicated in PP using Calculate and Filter but so far I was unable to replicate my specific scenario.
I was wondering if anyone could help me out.
I attached a sample Excel file with offset + match functions to show how it is currently done. I have also attached an example of PowerPivot with the same data in normalized tables where I am trying to reflect this calculation.
Please help
http://www.filedropper.com/excel-samplefile
http://www.filedropper.com/powerpivot-examplefile