Скачать или смотреть Power BI: using variables (part 2)

To use variables, follow the two steps:

1. Create a measure and add the variables, by writing VAR var_name = [Valid DAX formula]

2. Return the calculation for the set variable by writing RETURN [Another DAX formula with the variable used as part of the calculation.

Download sample file: https://bit.ly/31lsjQ8

The DAX formula used in the video example:

Profit in Russia =
VAR TotalSalesRussia = CALCULATE(
SUMX( Sales, Sales[UnitPrice] * Sales[SalesQuantity] ), Geography[RegionCountryName] = "Russia")

VAR TotalCostRussia = CALCULATE(
SUMX( sales, Sales[UnitCost] * Sales[SalesQuantity]), Geography[RegionCountryName] = "Russia")

RETURN
TotalSalesRussia - TotalCostRussia

To learn more about Power BI and DAX formulas, follow us on social media:   / centida  

#PowerBI #DAX #VAR