Microsoft Office Tutorials and References
In Depth Information
TABLE 2-2 using the date/time functions.
Column
Formula
Order Year
=YEAR (SalesOrderHeader[OrderDate])
Order Month
=MONTH (SalesOrderHeader[OrderDate])
You are using two DAX functions: YEAR and MONTH, which, as their name suggests, return
the year and the month of the date they receive as the parameter. Now you have two new
columns that let you slice the data by year and month. You can use these columns to produce
interesting reports, like the one in Figure 2-30, which aggregates at the year level.
FIguRE 2-30 Aggregating by year produces more interesting reports.
Or combining month and years, you can produce the report shown in Figure 2-31.
FIguRE 2-31 Combining years and months on the same report.
Search JabSto ::




Custom Search