اختبار شهادة مايكروسوفت Microsoft Power BI Data Analyst

You have a Power BI Desktop file named File1.pbix that contains a query named Query1.
You have a CSV file named File1.csv that contains three columns named OrderDate, OrderID, and Product ID.
Query1 imports File1.csv by using Power Query and includes transformation steps that remove top rows, promote headers, and
change multiple column data types.
You plan to create two additional queries:
• Query2 will filter rows to the last 30 days.
• Query3 will group rows by ProductID to create a summary table.
You need to create the additional queries. The solution must meet the following requirements:
• Changes to the cleanup steps in Query1 must automatically be reflected in Query2.
• Query3 must continue to use the current cleanup logic even if Query1 changes later.
• Only the final output queries must load to the semantic model.
What should you do?