Adaface Sample Power BI Questions

You are creating a Power BI report where users need to dynamically filter data based on a range of dates. The report has a Sales table with columns Date, ProductID, and Amount. You decide to use a Power Query parameter to allow users to select a start and end date, which will then filter the Sales table accordingly. The parameter is named DateRange and has a type of List. You need to write a Power Query M formula to filter the Sales table based on the selected date range. The DateRange parameter contains two dates: the first item is the start date, and the second item is the end date. How should the M formula be structured to achieve this functionality?

A: Table.SelectRows(Sales, each [Date] >= DateRange{0} and [Date] <= DateRange{1})
            
            B: Sales{[Date] >= DateRange{0}, [Date] <= DateRange{1}}
            
            C: Table.FilterRows(Sales, each [Date] >= List.First(DateRange) and [Date] <= List.Last(DateRange))
            
            D: Table.SelectRows(Sales, each [Date] >= List.First(DateRange) and [Date] <= List.Last(DateRange))
            
            E: Filter.Table(Sales, [Date] >= DateRange{0}, [Date] <= DateRange{1})

Consider the following two tables in Power BI:

We received the following error when we tried to set many-to-one cardinality between devices to users tables: “The cardinality you selected isn’t valid for this relationship”. What should we do before creating the many-to-one relationship?

Review the following Microsoft SQL Server table:

Complete the following Power Query formula used to create a custom column to replace the numbers present in last 11 characters of ISBN with 11 ‘*’. Example ‘978-0-365-51051-4’ is converted to ‘978-0-***-*****-*’

A: Text.Insert
            B: Text.Replace
            C: Text.Start
            D: Text.End