Introduction
Basic arithmetic in DAX lets you do simple math like adding, subtracting, multiplying, and dividing numbers in your Power BI data. This helps you create new insights by calculating totals, differences, or ratios directly in your reports.
When you want to calculate total sales by adding amounts from different columns
When you need to find the difference between this year's and last year's revenue
When you want to multiply quantity by price to get total cost
When you want to divide total profit by total sales to get profit margin
When you want to create a new column that shows a simple calculation based on existing data