Use one of the most common prompts below, or write your own to begin.
Create a DAX measure to calculate total sales using Orders[TotalAmount] for completed orders in the current year based on Orders[OrderDate]
Calculate year-to-date revenue for all sales, excluding refunded or cancelled orders
Find the average order value per month using Orders[TotalAmount] for the last 6 months
Compare total sales of the current month with the previous month and show the percentage change
