Power BI - Power Query Editor
You want to apply a filter step but keep the original data intact for comparison. How can you use Applied Steps to do this?
You want to apply a filter step but keep the original data intact for comparison. How can you use Applied Steps to do this?
hard📝 Scenario Q9 of 15
Step-by-Step Solution
Solution:
Step 1: Understand preserving original data
To keep original data, create a copy of the query before changes.Step 2: Duplicate query and apply filter on copy
Duplicating the query allows filtering on one copy while keeping the original unchanged.Final Answer:
Duplicate the query before applying the filter -> Option BQuick Check:
Duplicate query to preserve original data [OK]
Quick Trick: Duplicate queries to compare versions [OK]
Common Mistakes:
- Undoing after filtering loses changes
- Deleting steps loses original data
- Relying on Undo button repeatedly
Master "Power Query Editor" in Power BI
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore Power BI Quizzes