Power BI week 6

You have a dataset with sales data for multiple products and regions. You need to calculate the average sales per day for each product in Power BI. Which DAX function should you use?

• SUMX

• AVERAGEX

• COUNTX

• MAXX

You are working with a large dataset in Power Query, and you need to remove duplicate rows based on a specific column while keeping the row with the latest date. Which Power Query transformation should you use?

• Remove Duplicates

• Remove Columns

• Group By

• Sort Ascending

In Power BI, you have two tables: Sales and Products. You want to create a relationship between these tables using a column that is not unique in the Products table. Which type of relationship should you create?

• One-to-One

• One-to-Many

• Many-to-One

• Many-to-Many

You want to calculate the year-to-date sales for each product in Power BI. Which Time Intelligence DAX function should you use?

• TOTALYTD

• DATESYTD

• SAMEPERIODLASTYEAR

• DATEADD

You have a table in Power BI with a column that contains text values. You want to transform this column into a numerical value based on a custom mapping you've created. Which Power Query function should you use?

• Table.TransformColumns

• Table.AddColumn

• Text.Split

• Table.ReplaceValue

You need to calculate the moving average of sales for the last 3 months in Power BI. Which DAX function should you use?

• AVERAGEX

• MOVINGAVERAGE

• SUMX

• EARLIER

You have a complex data model in Power BI, and you want to optimize the performance of your report. Which feature or technique can you use to improve query performance?

• Import Data

• DirectQuery

• Aggregations

• Row-Level Security

You want to transform a column of dates in Power Query into a column of week numbers. Which Power Query function can you use to achieve this?

• Date.WeekOfYear

• Date.ToText

• Date.Year

• Date.AddDays

You need to calculate the cumulative sum of sales in Power BI over time. Which DAX function should you use?

• SUMMARIZE

• FILTER

• SUMX

• RANKX

You have a dataset with timestamps, and you want to create a custom calendar table with fiscal years starting in July. Which Power Query step should you use to create the custom fiscal year column?

• Custom Column

• Group By

• Add Index Column

• Filter Rows