Data Analysis Expressions (DAX) Reference by Reference

Author:Reference
Language: eng
Format: mobi, epub
Publisher: Microsoft Corporation
Published: 2012-06-20T16:00:00+00:00

June 1

June 1 sales

June 2

June 2 sales

(no order dates have been entered)

June 3 sales

Click here to view table as image

If you used the DISTINCT function to return a list of dates from the PivotTable containing these tables, only two dates would be returned. However, if you use the VALUES function, the function returns the two dates plus an additional blank member. Also, any row from the MySales table that does not have a matching date in the MyOrders table will be “matched” to this unknown member.

Example

Description

The following formula counts the number of unique invoices (sales orders), and produces the following results when used in a report that includes the Product Category Names:

Row Labels

Count Invoices

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.