Power BI Basics
What is the main use of Power BI?
To visualize and analyze data.
Where do we clean data in Power BI?
In Power Query Editor.
Which chart is best for comparing categories?
Bar or Column Chart.
What does SUM() do?
Adds numeric values.
What does CALCULATE() do?
Changes/modifies filter context.
What is the difference between Desktop and Service?
Desktop is for building, Service is for sharing.
What does “Remove Duplicates” do?
Removes repeated rows.
Which visual is used to show trends over time?
Line Chart.
What is the difference between a Calculated Column and a Measure?
Column is stored, Measure is calculated on the fly.
What does TOTALYTD() calculate?
Year-to-Date values.
What is a Report vs Dashboard?
Report = multiple pages, Dashboard = one page overview.
What is the difference between Merge and Append Queries?
Merge combines columns; Append stacks rows.
What do Slicers do?
Allow users to filter visuals interactively.
What does DISTINCTCOUNT() do?
Counts unique values.
What does SAMEPERIODLASTYEAR() allow us to compare?
Sales/metrics vs previous year.
What is a Dataset?
The data that is imported or connected to Power BI.
What is the step-by-step applied history called?
Applied Steps.
When do we use a Matrix instead of a Table?
When we want row + column grouping.
Why do we use IF() in DAX?
To apply conditional logic.
What is a Date Table used for?
To enable accurate time intelligence.
What is Data Model?
The relationship structure between tables.
What does the “Data Type” option under Column Tools control?
It defines how Power BI interprets the column (Text, Number, Date, etc.), affecting calculations and visuals.
What is Conditional Formatting used for?
To highlight values based on conditions(rules).
What is FILTER context?
The set of filters that affect a calculation.
What does the RELATED() function do in DAX?
It brings a column from a related (lookup) table into the current table.