Adding more tables to the Data Model using Existing Connection – In PowerPivot
Add relationships to Data Model in PowerPivot
My requirement is to retrieve only records related to Sales.
We will apply filter on Entry Type field to value [1]-[Sales] this way Item Leger Entry Sheet will have only Sales Data.
To do this we will add this filter to the query used for data retrieval.
![PowerPivot-15](https://msdynamicsnavashwinitripathi.files.wordpress.com/2015/09/poverpivot-15.jpg)
Select the Sheet for table – Item Ledger Entry from bottom.
Click on Design Tab on Top.
Now From Ribbon choose Table Properties.
![PowerPivot-16](https://msdynamicsnavashwinitripathi.files.wordpress.com/2015/09/poverpivot-16.jpg)
Select Query Editor from Switch to.
Add the Filter to your query.
Save your Query.
![PowerPivot-17](https://msdynamicsnavashwinitripathi.files.wordpress.com/2015/09/poverpivot-17.jpg)
From Home Tab, Select Refresh from Ribbon.
On Success completion Close the window.
Now your Item Ledger Entry is populated with Fresh data as per the modified Query.
I.e: All Entries which have Entry Type = 1 [Sales].
I will come up with more details in my upcoming post, till then keep practicing and stay tuned for future updates & posts on this topic.
[…] How to add Filter for data retrieval in PowerPivot Data model. […]
ReplyDelete[…] How to add Filter for data retrieval in PowerPivot Data model. […]
ReplyDelete[…] How to add Filter for data retrieval in PowerPivot Data model. […]
ReplyDelete