Learnify Interview Questions and Answers

Filter context in Power BI determines which data is visible to calculations in a report.

• Filter context is used to filter data based on user interactions or predefined filters.

• It helps in determining which rows of data are visible to calculations in a report.

• Filter context can be applied at different levels such as report level, page level, or visual level.

• Examples of filter context include slicers, filters, and cross-f

Inner join and left join are types of SQL joins used to combine data from two or more tables based on a related column.

• Inner join returns only the rows that have matching values in both tables

• Left join returns all the rows from the left table and the matched rows from the right table

• The main difference is that inner join only includes rows where the join condition is met, while left join includes all rows from the left