Power BI Study guides, Class notes & Summaries

Power BI Certification Exam - DAX Formulas () | Questions & Answers (100% Verified) Power BI Certification Exam - DAX Formulas () | Questions & Answers (100% Verified) CALENDAR - ANSWER - Syntax: CALENDAR(<start_date>, <end_date>) Parameters: start_date - any DAX expression that returns a datetime value end_date - any DAX expression that returns a datetime value Return Value: Returns a table with a single column named "Date" containing a contiguous set of dates, inclu...

Microsoft Power BI 70-778 Certification Exam | Questions & Answers (Rated A+) Microsoft Power BI 70-778 Certification Exam | Questions & Answers (Rated A+) You have a Power BI model for sales data. You need to create a measure to calculate the year-to-date sales and to compare those sales to the previous year for the same time period. Which DAX function should you use? a) PARALELLPERIOD b) SAMEPERIODLASTYEAR c) DATESYTD d) PREVIOUSYEAR - ANSWER - c) DATESYTD You have a Power BI report...

PowerBI Certification Exam (2023) | Questions & Answers (Graded A+) PowerBI Certification Exam (2023) | Questions & Answers (Graded A+) If you want your data to automatically refresh as you interact with visualizations, which option should you choose? A) Import B) DirectQuery - ANSWER - B) DirectQuery Explanation: When you use DirectQuery, no data is imported into Power BI Desktop. As you create or interact with a visualization, PowerBI Desktop queries the underlying data source, i.e. ...

Power BI Test | Questions with 100% Correct Answers | Latest Update 2024 | Verified

Power BI Test | Questions with 100% Correct Answers | Latest Update 2024 | Verified

What type of expression do you use to extract data from Microsoft SQL Server? A. DAX B. T-SQL C. MDX - B. T-SQL You're creating a Power BI report with data from an Azure Analysis Services Cube. When the data refreshes in the cube, you would like to see it immediately in the Power BI report. How should you connect? A. Import B. Connect live C. Direct Query - B. Connect live What can you do to improve performance when you are getting data in Power BI? A. Do some calculations in the ori...

What is a risk of having null values in a numeric column? That function SUM of data will be incorrect. That function MAX of data will be incorrect. That function AVERAGE of data will be incorrect. - That function AVERAGE of data will be incorrect. If you have two queries that have different data but the same column headers, and you want to combine both tables into one query with all the combined rows, which operation should you perform? Append Merge Combine Column - Append Which of th...

What is the common flow of activity in Power BI? - Create a report in Power BI mobile, share it to the Power BI Desktop, view and interact in the Power BI service. -Create a report in the Power BI service, share it to Power BI mobile, interact with it in Power BI Desktop. -Bring data into Power BI Desktop and create a report, share it to the Power BI service, view and interact with reports and dashboards in the service and Power BI mobile. -Bring data into Power BI mobile, create a report...