Beginning Power BI by Dan Clark

Beginning Power BI by Dan Clark

Author:Dan Clark
Language: eng
Format: epub, pdf
Publisher: Apress, Berkeley, CA


where expression is an expression that returns a scalar value. dates is the date table’s key column. filter is an optional filter expression, and year_end_date is also optional—you can use it to indicate the year end of a fiscal calendar. The following expressions are used to calculate the sum of the sales and the sales year-to-date values.

Sum of Sales:=SUM(Sales[SalesAmount])

YTD Sales:=TOTALYTD([Sum of Sales],'Date'[Datekey])

If you want to calculate year-to-date sales for all products , use the following expression:

YTD Sales ALL Products:=TOTALYTD([Sum of Sales],'Date'[Datekey],ALL('Product'))



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.