Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Solved! Go to Solution.
This DAX expression is used to calculate a value based on certain conditions. Here's how it works:
It first checks if the column [Price per Unit - PY $] is blank. If it is, the result is also set to blank, and the calculation stops. This condition handles cases where the price for the previous year is missing or not available.
If the [Price per Unit - PY $] is not blank, it proceeds to the next step. It filters the data in the table FactSalesInvoiceLine based on the following conditions:
For the filtered rows, it performs a calculation. It multiplies the values in the columns [Unit Quantity - CY] and [Price per Unit - CY vs PY $].
Finally, it sums up the results of these calculations for all the filtered rows, providing the final result.
Proud to be a Super User! | |
This DAX expression is used to calculate a value based on certain conditions. Here's how it works:
It first checks if the column [Price per Unit - PY $] is blank. If it is, the result is also set to blank, and the calculation stops. This condition handles cases where the price for the previous year is missing or not available.
If the [Price per Unit - PY $] is not blank, it proceeds to the next step. It filters the data in the table FactSalesInvoiceLine based on the following conditions:
For the filtered rows, it performs a calculation. It multiplies the values in the columns [Unit Quantity - CY] and [Price per Unit - CY vs PY $].
Finally, it sums up the results of these calculations for all the filtered rows, providing the final result.
Proud to be a Super User! | |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
82 | |
74 | |
66 |
User | Count |
---|---|
120 | |
105 | |
99 | |
81 | |
72 |