Post #2256

Power BI Interview Questionswith Answers Part-2✅ 11. What are relationships in Power BI? Relationships define how data tables are connected through common columns (keys), enabling you to combine and analyze related data effectively across tables. 12. What are the different types of relationships in Power BI? ⦁ One-to-many: One row in table A relates to multiple rows in table B. ⦁ One-to-one: One row in table A relates to exactly one row in table B. ⦁ Many-to-many: Multiple rows in one table relate to multiple rows in another, supported via bridge tables. 13. What is cardinality in Power BI? Cardinality refers to the uniqueness of data values in a column that participates in a relationship, e.g., one-to-many cardinality means a unique key on one side and non-unique on the other. 14. What is cross-filter direction in Power BI? It determines how filters flow between related tables: ⦁ Single: Filters flow in one direction. ⦁ Both: Filters flow both ways, enabling bi-directional filtering in reports. 15. How do you create calculated columns and measures? Use DAX formulas in Power BI Desktop: ⦁ Calculated columns add extra columns at row level stored in the data model. ⦁ Measures are calculations performed dynamically on aggregated data during report interactions. 16. What is DAX? DAX (Data Analysis Expressions) is a formula language tailored for Power BI for creating custom calculations like calculated columns, measures, filtering, and aggregations within the data model. 17. Explain the difference between calculated columns and measures. ⦁ Calculated columns compute values row by row when data is loaded and store them. ⦁ Measures compute results on-the-fly, aggregate data dynamically depending on the filter context. 18. List some common DAX functions. Common functions include: ⦁ SUM(), AVERAGE(), COUNT(), RELATED(), CALCULATE(), FILTER(), IF(), ALL(), VALUES(). 19. What is the CALCULATE function in DAX? CALCULATE() modifies the filter context of a calculation, enabling complex conditional logic and dynamic aggregation based on filters. 20. How do you use variables in DAX? Variables store intermediate values in a DAX formula for better readability and performance, declared using VAR and returned using RETURN. Double Tap ❤️ for Part-3