How to Create New Tables from Existing Ones Using DAX FILTER Function | 2024 |
Learn Power BI in 2024
NEW data from the existing tables in PowerBI without messing up the original Data.
Sample Files Link : https://github.com/aashiKT/lets_grow_...
Sample File Name : Create new tables thru filter function in Power BI
Hello friends! In today’s video, we'll discover how to transform existing tables into new ones with the powerful FILTER function in DAX. I will guide you through step-by-step examples, including filtering by product brand, using nested FILTER functions, filtering by product color, and some advanced techniques. Let’s dive in! 🌟
Explanation for Nested Filter:
• The first FILTER function filters the 'Product' table where the brand is 'TechCorp' (this is the inner filter).
• The second FILTER function further filters the result from the first filter where 'Unit Price' is 4 times more than 'Unit Cost' (this is the outer filter).
• This process creates a new table 'HighMarginTechCorpProducts' that shows high margin products of the 'TechCorp' brand.
Explanation of AND (&&):
The AND operator (&&) is used to combine two conditions, meaning both conditions must be true. This is useful when we need to check multiple conditions simultaneously.
Music Credit:
The Dark Glow of the Mountains by Chris Zabriskie is licensed under a Creative Commons Attribution 4.0 license. https://creativecommons.org/licenses/... Source: http://chriszabriskie.com/darkglow/ Artist: http://chriszabriskie.com/
Don't miss out on the chance to master DAX and take your Power BI skills to the next level! Hit that subscribe button and stay tuned for more powerful tutorials!
#PowerBI #DAX #DataTransformation #LearnWithMe #TechTips #DataAnalysis #PowerBITutorials