![]() The table is marked as a date table using the Date column.ĭescribes resellers and their geographic location. The company's reports sales using a fiscal year that commences on July 1 of each year. There are three relationships between the Date and Sales tables, for order date, ship date, and due date. Customers purchase products online (Internet sales). Model structureĭescribes customers and their geographic location. The company has their data warehouse data stored in an Azure SQL Database. The Adventure Works company represents a bicycle manufacturer that sells bicycles and accessories to global markets. ![]() We're working on including more examples in other function reference articles that work with the sample model. Some function examples, like those in CALCULATE, DATESBETWEEN, DATESIN PERIOD, IF, and LOOKUPVALUE can be added to the sample model without modification. It does however support hundreds or even thousands of potential calculation formulas and queries. The sample model does not contain any DAX formulas. The model is based on the Adventure Works data warehouse sample for AdventureWorksDW2017-however, the data has been modified to suit the objectives of the sample model. The Adventure Works DW 2020 Power BI Desktop sample model is designed to support your DAX learning.
0 Comments
Leave a Reply. |