{"id":14868,"date":"2026-09-17T07:43:12","date_gmt":"2026-09-17T07:43:12","guid":{"rendered":"https:\/\/www.examlabs.com\/certification\/?p=14868"},"modified":"2026-09-17T07:43:12","modified_gmt":"2026-09-17T07:43:12","slug":"microsoft-pl-300-practice-test-questions-and-exam-dumps-part19-q361-380","status":"publish","type":"post","link":"https:\/\/www.examlabs.com\/certification\/microsoft-pl-300-practice-test-questions-and-exam-dumps-part19-q361-380\/","title":{"rendered":"Microsoft PL-300 Practice Test Questions and Exam Dumps Part19 Q361-380"},"content":{"rendered":"

<\/h1>\n

View Full <\/b>Microsoft PL-300 Exam Dumps<\/b><\/a> and Practice Test Dumps.<\/b><\/h2>\n

 <\/p>\n

Question 361<\/b><\/h3>\n

Which DAX function can return the total sales while preserving filters selected outside the current visual?<\/b><\/p>\n

    \n
  1. ALL<\/span><\/li>\n
  2. REMOVEFILTERS<\/span><\/li>\n
  3. ALLSELECTED<\/span><\/li>\n
  4. DISTINCT<\/span><\/li>\n<\/ol>\n

    Correct Answer: 3<\/b><\/p>\n

    Explanation<\/b><\/p>\n

    ALLSELECTED returns values while retaining filters that come from outside the current visual or query context. It is commonly used for calculations such as visual totals, where a measure should compare the current selection with the broader selection made by the report user. For example, ALLSELECTED can help calculate a product’s percentage of the total visible across a selected region. ALL and REMOVEFILTERS remove specified filters more broadly, while DISTINCT returns unique values. Therefore, ALLSELECTED is appropriate when external selections should remain part of the calculation.<\/span><\/p>\n

    Question 362<\/b><\/h3>\n

    Which Power Query transformation can reverse the order of rows in a table?<\/b><\/p>\n

      \n
    1. Reverse Rows<\/span><\/li>\n
    2. Sort Rows<\/span><\/li>\n
    3. Transpose<\/span><\/li>\n
    4. Keep Bottom Rows<\/span><\/li>\n<\/ol>\n

      Correct Answer: 1<\/b><\/p>\n

      Explanation<\/b><\/p>\n

      Reverse Rows changes the order of records so that the last row becomes the first and the first row becomes the last. This can be useful when source data is arranged in reverse chronological order or when a transformation requires records to be processed from the opposite direction. Sort Rows orders records according to selected column values, while Transpose switches rows and columns. Keep Bottom Rows retains a specified number of records rather than reversing their order. Therefore, Reverse Rows is the appropriate Power Query transformation.<\/span><\/p>\n

      Question 363<\/b><\/h3>\n

      Which DAX function can return the number of unique values in a column while excluding blank values?<\/b><\/p>\n

        \n
      1. COUNTROWS<\/span><\/li>\n
      2. DISTINCTCOUNTNOBLANK<\/span><\/li>\n
      3. DISTINCTCOUNT<\/span><\/li>\n
      4. COUNTA<\/span><\/li>\n<\/ol>\n

        Correct Answer: 2<\/b><\/p>\n

        Explanation<\/b><\/p>\n

        DISTINCTCOUNTNOBLANK counts distinct values in a column while excluding blank values. It is useful when the analysis requires the number of unique meaningful entries and missing values should not contribute to the result. For example, it can count unique customer IDs while ignoring records where CustomerID is blank. DISTINCTCOUNT can include a blank as a distinct value, COUNTROWS counts table records, and COUNTA counts nonblank values without specifically performing a distinct count. Therefore, DISTINCTCOUNTNOBLANK is the correct function.<\/span><\/p>\n

        Question 364<\/b><\/h3>\n

        Which Power BI visual is most appropriate for showing the composition of a total using segments within a circle?<\/b><\/p>\n

          \n
        1. Treemap<\/span><\/li>\n
        2. Donut chart<\/span><\/li>\n
        3. Scatter chart<\/span><\/li>\n
        4. Gauge<\/span><\/li>\n<\/ol>\n

          Correct Answer: 2<\/b><\/p>\n

          Explanation<\/b><\/p>\n

          A Donut chart displays categories as segments of a circular ring, allowing users to compare each category’s contribution to the overall total. It is useful when the number of categories is relatively small and the main purpose is to show proportions. A Treemap uses rectangular areas, a Scatter chart shows relationships between numerical variables, and a Gauge displays progress toward a target. Therefore, a Donut chart is the appropriate visual when the composition of a total needs to be represented using circular segments.<\/span><\/p>\n

          Question 365<\/b><\/h3>\n

          Which DAX function can return a table filtered according to a specified Boolean condition?<\/b><\/p>\n

            \n
          1. VALUES<\/span><\/li>\n
          2. FILTER<\/span><\/li>\n
          3. DISTINCT<\/span><\/li>\n
          4. ALL<\/span><\/li>\n<\/ol>\n

            Correct Answer: 2<\/b><\/p>\n

            Explanation<\/b><\/p>\n

            FILTER returns a table containing only the rows that satisfy a specified condition. It is frequently used inside more complex DAX calculations when the required filtering logic cannot be expressed using a simple column filter. For example, FILTER can return sales rows where the transaction amount is greater than a particular threshold. VALUES returns values from the current context, DISTINCT returns unique values, and ALL removes filters. Therefore, FILTER is the appropriate DAX function when a table needs to be restricted according to a condition.<\/span><\/p>\n

            Question 366<\/b><\/h3>\n

            Which Power Query feature allows a user to create a copy of an existing query and its transformation steps?<\/b><\/p>\n

              \n
            1. Reference<\/span><\/li>\n
            2. Duplicate<\/span><\/li>\n
            3. Merge<\/span><\/li>\n
            4. Append<\/span><\/li>\n<\/ol>\n

              Correct Answer: 2<\/b><\/p>\n

              Explanation<\/b><\/p>\n

              Duplicate creates a separate copy of an existing Power Query query, including its transformation steps. This can be useful when two queries need to begin with the same source and initial transformations but later follow different processing paths. Reference instead creates a query based on the output of another query, allowing the new query to depend on the existing result. Merge combines tables using matching columns, while Append combines rows from multiple queries. Therefore, Duplicate is the appropriate feature for creating an independent copy of a query.<\/span><\/p>\n

              Question 367<\/b><\/h3>\n

              Which DAX function can return the quarter number from a date value?<\/b><\/p>\n

                \n
              1. MONTH<\/span><\/li>\n
              2. QUARTER<\/span><\/li>\n
              3. YEAR<\/span><\/li>\n
              4. WEEKNUM<\/span><\/li>\n<\/ol>\n

                Correct Answer: 2<\/b><\/p>\n

                Explanation<\/b><\/p>\n

                QUARTER returns the quarter number associated with a date, producing a value from 1 through 4. This can be useful when creating calculated columns or grouping report data by fiscal or calendar quarter. For example, a date in September belongs to quarter 3 of a standard calendar year. MONTH returns the month number, YEAR returns the year, and WEEKNUM returns the week number within a year. Therefore, QUARTER is the appropriate DAX function when the quarter component of a date is required.<\/span><\/p>\n

                Question 368<\/b><\/h3>\n

                Which Power BI feature allows users to view a report in a layout optimized for smaller screens?<\/b><\/p>\n

                  \n
                1. Mobile layout<\/span><\/li>\n
                2. Theme<\/span><\/li>\n
                3. Tooltip<\/span><\/li>\n
                4. Bookmark<\/span><\/li>\n<\/ol>\n

                  Correct Answer: 1<\/b><\/p>\n

                  Explanation<\/b><\/p>\n

                  Mobile layout provides a report design specifically optimized for smaller screens such as smartphones. Report authors can rearrange supported visuals and adjust their sizes so that important information remains readable and accessible on mobile devices. The desktop layout can remain unchanged while the mobile layout provides a more suitable presentation for phone users. Themes control visual formatting, Tooltips display additional information, and Bookmarks save report states. Therefore, Mobile layout is the appropriate Power BI feature for creating a small-screen report experience.<\/span><\/p>\n

                  Question 369<\/b><\/h3>\n

                  Which DAX function can activate a relationship that is inactive in the model for a specific calculation?<\/b><\/p>\n

                    \n
                  1. RELATED<\/span><\/li>\n
                  2. USERELATIONSHIP<\/span><\/li>\n
                  3. CROSSFILTER<\/span><\/li>\n
                  4. LOOKUPVALUE<\/span><\/li>\n<\/ol>\n

                    Correct Answer: 2<\/b><\/p>\n

                    Explanation<\/b><\/p>\n

                    USERELATIONSHIP activates an existing inactive relationship while a calculation is being evaluated. This is particularly useful when two tables have multiple possible relationships, such as a Sales table containing both OrderDate and ShipDate connected to the same Date table. One relationship can be active by default while USERELATIONSHIP allows a measure to temporarily use the alternative relationship. RELATED retrieves a related value, CROSSFILTER changes filter direction, and LOOKUPVALUE searches for matching values. Therefore, USERELATIONSHIP is correct.<\/span><\/p>\n

                    Question 370<\/b><\/h3>\n

                    Which Power Query transformation can change a column from text containing separate values into multiple fields using a delimiter?<\/b><\/p>\n

                      \n
                    1. Merge Columns<\/span><\/li>\n
                    2. Split Column<\/span><\/li>\n
                    3. Pivot Column<\/span><\/li>\n
                    4. Group By<\/span><\/li>\n<\/ol>\n

                      Correct Answer: 2<\/b><\/p>\n

                      Explanation<\/b><\/p>\n

                      Split Column can separate the contents of one column into multiple columns using a delimiter, character count, or another supported method. For example, a column containing “John Smith” can be divided into First Name and Last Name using a space delimiter. This is useful when source systems store multiple pieces of information in a single field. Merge Columns performs the reverse operation by combining fields, Pivot Column restructures values, and Group By creates summaries. Therefore, Split Column is the correct transformation.<\/span><\/p>\n

                      Question 371<\/b><\/h3>\n

                      Which DAX function can return a value based on multiple conditions without requiring nested IF statements?<\/b><\/p>\n

                        \n
                      1. SWITCH<\/span><\/li>\n
                      2. FORMAT<\/span><\/li>\n
                      3. COALESCE<\/span><\/li>\n
                      4. ABS<\/span><\/li>\n<\/ol>\n

                        Correct Answer: 1<\/b><\/p>\n

                        Explanation<\/b><\/p>\n

                        SWITCH evaluates an expression against multiple possible values or conditions and returns the corresponding result. It can make DAX logic easier to read when several outcomes are possible. For example, a sales measure can classify performance as High, Medium, or Low based on predefined conditions. This can be easier to maintain than deeply nested IF statements. FORMAT converts values to text, COALESCE returns the first nonblank expression, and ABS returns an absolute value. Therefore, SWITCH is appropriate for handling multiple conditional outcomes.<\/span><\/p>\n

                        Question 372<\/b><\/h3>\n

                        Which Power BI feature allows a report author to control whether selecting one visual filters or highlights another visual?<\/b><\/p>\n

                          \n
                        1. Edit Interactions<\/span><\/li>\n
                        2. Sync Slicers<\/span><\/li>\n
                        3. Bookmarks<\/span><\/li>\n
                        4. Query Dependencies<\/span><\/li>\n<\/ol>\n

                          Correct Answer: 1<\/b><\/p>\n

                          Explanation<\/b><\/p>\n

                          Edit Interactions controls how visuals respond to selections made in other visuals on the same report page. A report author can configure an interaction so that a selection filters another visual, highlights it, or has no effect on it. This provides greater control over the report’s analytical behavior and user experience. Sync Slicers synchronizes slicer selections between pages, Bookmarks save report states, and Query Dependencies displays query relationships. Therefore, Edit Interactions is the correct feature for controlling visual interactions.<\/span><\/p>\n

                          Question 373<\/b><\/h3>\n

                          Which DAX function can return the first nonblank value from a column according to an expression?<\/b><\/p>\n

                            \n
                          1. FIRSTDATE<\/span><\/li>\n
                          2. FIRSTNONBLANK<\/span><\/li>\n
                          3. MIN<\/span><\/li>\n
                          4. VALUES<\/span><\/li>\n<\/ol>\n

                            Correct Answer: 2<\/b><\/p>\n

                            Explanation<\/b><\/p>\n

                            FIRSTNONBLANK returns the first value in a column for which a specified expression is not blank. It is useful when a calculation needs to identify the earliest meaningful value rather than simply the first value in the column. For example, it can help identify the first date associated with recorded sales activity. FIRSTDATE returns the first date in the current context, MIN returns the smallest value, and VALUES returns a table of values. Therefore, FIRSTNONBLANK is the appropriate function for finding the first nonblank result.<\/span><\/p>\n

                            Question 374<\/b><\/h3>\n

                            Which Power BI feature allows report authors to organize visuals and control their visibility on a report page?<\/b><\/p>\n

                              \n
                            1. Selection pane<\/span><\/li>\n
                            2. Data view<\/span><\/li>\n
                            3. Model view<\/span><\/li>\n
                            4. Query Dependencies<\/span><\/li>\n<\/ol>\n

                              Correct Answer: 1<\/b><\/p>\n

                              Explanation<\/b><\/p>\n

                              The Selection pane provides a list of objects on a report page and allows authors to manage their visibility and layering order. It is especially useful when a page contains overlapping visuals, buttons, shapes, or images. Authors can hide objects temporarily and organize their stacking order without deleting them. Data view is used to inspect table data, Model view manages relationships and model structure, and Query Dependencies displays connections between queries. Therefore, Selection pane is the appropriate feature for managing report-page objects.<\/span><\/p>\n

                              Question 375<\/b><\/h3>\n

                              Which DAX function can return the current date and time?<\/b><\/p>\n

                                \n
                              1. TODAY<\/span><\/li>\n
                              2. NOW<\/span><\/li>\n
                              3. DATE<\/span><\/li>\n
                              4. TIME<\/span><\/li>\n<\/ol>\n

                                Correct Answer: 2<\/b><\/p>\n

                                Explanation<\/b><\/p>\n

                                NOW returns the current date and time as a datetime value. It is useful when calculations need to consider both the current date and the current time, such as determining elapsed time or comparing timestamps. TODAY returns only the current date without the time component. DATE creates a date from specified year, month, and day values, while TIME creates a time value from specified hour, minute, and second components. Therefore, NOW is the correct DAX function when both the current date and time are required.<\/span><\/p>\n

                                Question 376<\/b><\/h3>\n

                                Which Power Query feature allows users to inspect the distribution and quality of values within columns?<\/b><\/p>\n

                                  \n
                                1. Column Profiling<\/span><\/li>\n
                                2. Query Dependencies<\/span><\/li>\n
                                3. Merge Queries<\/span><\/li>\n
                                4. Applied Steps<\/span><\/li>\n<\/ol>\n

                                  Correct Answer: 1<\/b><\/p>\n

                                  Explanation<\/b><\/p>\n

                                  Column Profiling provides information about the contents and quality of data in Power Query columns. It can help users examine value distributions, identify errors, and detect empty or unexpected values during data preparation. This makes it useful for discovering data-quality issues before the dataset is loaded into the Power BI model. Query Dependencies shows relationships between queries, Merge Queries combines related tables, and Applied Steps lists transformations applied to the current query. Therefore, Column Profiling is the appropriate feature for inspecting column quality.<\/span><\/p>\n

                                  Question 377<\/b><\/h3>\n

                                  Which DAX function can return the total for a year-to-date period without requiring a manually constructed date filter?<\/b><\/p>\n

                                    \n
                                  1. TOTALYTD<\/span><\/li>\n
                                  2. DATESYTD<\/span><\/li>\n
                                  3. YEAR<\/span><\/li>\n
                                  4. PREVIOUSYEAR<\/span><\/li>\n<\/ol>\n

                                    Correct Answer: 1<\/b><\/p>\n

                                    Explanation<\/b><\/p>\n

                                    TOTALYTD calculates an expression over the year-to-date period based on the current date context. It simplifies common year-to-date calculations because the function handles the accumulation of values from the beginning of the year through the current date. For example, TOTALYTD([Total Sales], ‘Date'[Date]) can calculate cumulative sales for the current year. DATESYTD returns a date table rather than directly calculating the expression, YEAR extracts a year number, and PREVIOUSYEAR references the prior year. Therefore, TOTALYTD is correct.<\/span><\/p>\n

                                    Question 378<\/b><\/h3>\n

                                    Which Power BI relationship direction allows filters to propagate from both related tables?<\/b><\/p>\n

                                      \n
                                    1. Single<\/span><\/li>\n
                                    2. Both<\/span><\/li>\n
                                    3. Forward<\/span><\/li>\n
                                    4. None<\/span><\/li>\n<\/ol>\n

                                      Correct Answer: 2<\/b><\/p>\n

                                      Explanation<\/b><\/p>\n

                                      The Both cross-filter direction allows filters to propagate between both tables participating in a relationship. This can be useful in certain modeling scenarios where filtering either table needs to affect the other table. However, bidirectional filtering should be used carefully because unnecessary relationships in both directions can introduce ambiguity or unexpected filtering behavior. Single allows filtering primarily in one direction, while Forward and None are not standard cross-filter direction choices in Power BI relationships. Therefore, Both is the correct option.<\/span><\/p>\n

                                      Question 379<\/b><\/h3>\n

                                      Which DAX function can return a table of dates from the beginning of the current month through the selected date?<\/b><\/p>\n

                                        \n
                                      1. DATESMTD<\/span><\/li>\n
                                      2. TOTALMTD<\/span><\/li>\n
                                      3. DATEADD<\/span><\/li>\n
                                      4. MONTH<\/span><\/li>\n<\/ol>\n

                                        Correct Answer: 1<\/b><\/p>\n

                                        Explanation<\/b><\/p>\n

                                        DATESMTD returns a table containing dates from the beginning of the current month through the last date in the current filter context. It is useful when constructing custom month-to-date calculations with CALCULATE or other DAX functions. TOTALMTD directly calculates an expression over the month-to-date period, while DATEADD shifts a date context and MONTH extracts the month number. Therefore, DATESMTD is the appropriate function when the month-to-date date table itself is required.<\/span><\/p>\n

                                        Question 380<\/b><\/h3>\n

                                        Which Power BI feature allows users to subscribe to a report or dashboard and receive scheduled email updates?<\/b><\/p>\n

                                          \n
                                        1. Data alerts<\/span><\/li>\n
                                        2. Subscriptions<\/span><\/li>\n
                                        3. Bookmarks<\/span><\/li>\n
                                        4. Drillthrough<\/span><\/li>\n<\/ol>\n

                                          Correct Answer: 2<\/b><\/p>\n

                                          Explanation<\/b><\/p>\n

                                          Subscriptions allow users to receive scheduled email snapshots or updates related to Power BI reports and dashboards, depending on the available service capabilities and permissions. This can help users stay informed without manually opening the report each time. Data alerts are designed to notify users when a monitored dashboard value reaches a specified condition. Bookmarks save report states, while Drillthrough provides navigation to detailed pages. Therefore, Subscriptions is the appropriate Power BI feature for receiving scheduled report-related email updates.<\/span><\/p>\n

                                           <\/p>\n","protected":false},"excerpt":{"rendered":"

                                          View Full Microsoft PL-300 Exam Dumps and Practice Test Dumps.   Question 361 Which DAX function can return the total sales while preserving filters selected outside the current visual? ALL REMOVEFILTERS ALLSELECTED DISTINCT Correct Answer: 3 Explanation ALLSELECTED returns values while retaining filters that come from outside the current visual or query context. It is […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1648,1647],"tags":[],"_links":{"self":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/14868"}],"collection":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/comments?post=14868"}],"version-history":[{"count":1,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/14868\/revisions"}],"predecessor-version":[{"id":14922,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/14868\/revisions\/14922"}],"wp:attachment":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/media?parent=14868"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/categories?post=14868"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/tags?post=14868"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}