Data modeling

Studying the nuances of the data

Aggregating columns containing numeric data

On the Fields list, click the ellipsis next to the Sales table or right-click any field in the Sales table, and then click New Measure.

Click New Measure, and then type in the formula Home Table = Sales

Create the measure from any table, and then set the Home Table properties to Sales.

Select the Sales table in the Fields list, and then click New Measure in the Modeling ribbon.

Synonyms

Duplicate Name

Alternative

Implement Dynamic row-level security

Create one report for each category manager, with a different category filter in each report, and a separate report for the CEO.

Create a category slicer in the report.

Modeling -> Select Month Column -> Sort By – MonthNumber

Click on ellipses on Right Top Corner of visual -> Sort by – MonthNumber

Right Click on field in report view and select sort by, then select MonthNumber

DAX expressions that SUM data will be incorrect

DAX expressions that MAX data will be incorrect

DAX expressions that AVERAGE data will be incorrect

To perform different types of merge join

To create a table based on the result of a function or formula

To union tables

To improve the speed and performance of an existing table

A Slicer visual from a Power BI report can be pinned to a dashboard to make the dashboard interactive.

A Slicer visual is used on Power BI reports to provide the report consumer with interactive filtering behavior.

When adding a field to the Field well of a Slicer visual, you can use either a column or a measure.

Column profile

Column quality & column profile

Column distribution

Column quality

True

False