Search icon
Subscription
0
Cart icon
Close icon
You have no products in your basket yet
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Expert Data Modeling with Power BI - Second Edition

You're reading from  Expert Data Modeling with Power BI - Second Edition

Product type Book
Published in Apr 2023
Publisher Packt
ISBN-13 9781803246246
Pages 698 pages
Edition 2nd Edition
Languages
Author (1):
Soheil Bakhshi Soheil Bakhshi
Profile icon Soheil Bakhshi

Table of Contents (22) Chapters

Preface 1. Section I: Data Modeling in Power BI
2. Introduction to Data Modeling in Power BI 3. Data Analysis eXpressions and Data Modeling 4. Section II: Data Preparation in Query Editor
5. Data Preparation in Power Query Editor 6. Getting Data from Various Sources 7. Common Data Preparation Steps 8. Star Schema Preparation in Power Query Editor 9. Data Preparation Common Best Practices 10. Section III: Data Modeling
11. Data Modeling Components 12. Star Schema and Data Modeling Common Best Practices 13. Section IV: Advanced Data Modeling
14. Advanced Data Modeling Techniques 15. Row-Level and Object-Level Security 16. Dealing with More Advanced Data Warehousing Concepts in Power BI 17. Introduction to Dataflows 18. DirectQuery Connections to Power BI Datasets and Analysis Services in Composite Models 19. New Options, Features, and DAX Functions 20. Other Books You May Enjoy
21. Index

Replacing values

In data cleansing, replacing values is one of the most common transformation activities. A simple example is when we have a description column in the source system containing free text, and we want to replace some parts of the description with something else.

Power Query Editor UI uses the Table.ReplaceValue(table as table, OldValue as any, NewValue as any, Replacer as function, columnsToSearch as list) function behind the scenes to replace a value in a table. If we want to replace the value of a List, it uses the List.ReplaceValue(list as list, OldValue as any, NewValue as any, Replacer as function) function. Depending on the value’s data type, the Replacer function can be either Replacer.ReplaceText or Replacer.ReplaceValue. The difference between the two is that we can use Replacer.ReplaceText to replace text values, while we can use Replacer.ReplaceValue to replace any values. For instance, if we want to replace semicolons with colons in a text column...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $15.99/month. Cancel anytime}