```*****Key Measures********
- Total Sales = sum(sales[total revenue])
- Total Quantity = sum(sales[order quantity])
- Total Profit  = calculate(sum(sales[total revenue])) -
calculate(sumx(sales, sales[order quantity]*
sales[total unit cost]))
- Profit % = DIVIDE([TOTAL PROFITS],[TOTAL SALES],0)```
```*****Time Comparison******
- sales LY =
if (
[total sales] <> blank(),
if (
HASONEVALUE('Date Table'[MonthName]),
calculate([total sales],SAMEPERIODLASTYEAR('Date Table'[Date])
),
CALCULATE([Total Sales], DATESBETWEEN('Date Table'[Date],EDATE(min('Date Table'[Date]),-12), EOMONTH(MAX(Sales[OrderDate]),-12)))))
- Sales 2yrs ago = calculate(sum(sales[total revenue]), DATEADD(dimdate[date],-2,year)) // you can do +2 as well```
```****Cumulative Measures*******- Cumulative Sales =
if (
[total sales] <> blank(),
calculate ([total sales],
filter( allselected(dates),
dates[date] <= Max( dates[date]))))

- Cumulative Performance ly =
if (
[total sales] <> blank(),
CALCULATE([sales ly],
filter(allselected(Dates), dates[date] <= MAX (Dates[Date])))
)```
```*******Moving Averages********

- Profits 30D MA      = averagex(dateinperiod(dates[date],lastdate(dates[date]),-30,day),
[total profit])

- Sales 30D MA      = averagex(dateinperiod(dates[date],lastdate(dates[date]),-30,day),
[total sales])

- Transactions 30D MA

total days transacting = distinctcount(sales[order date])

or

total transaction = countrows (sales)

= averagex(dateinperiod(dates[date],lastdate(dates[date]),-30,day),
[total transaction])

transactions in last 30 days

var last_date = lastdate(sales[order date])  or last_date = today()

return
calculate ([total transaction],
filter ( all (dates),
dates[date] > last_date - 30 &&
dates[date] <= last_date ))

```
```*****Key Measures********
- Total Sales - Total Quantity - Total Profit- Profit %
```
`*****Time Comparison******- Performance LY - Sales 2yrs ago  `
```****Cumulative Measures*******
- Cumulative Performance this year- Cumulative Performance last year```
```*******Moving Averages********
- Profits 30D MA- Sales 30D MA - Transactions 30D MA
```
```- Create a Date Table
- Create a Quarter Slicer
- Create 3 cards with line chart showing the Total Sales, Profit and % Profit.
- Show the sales Comparesion between Cumulative Performance vs Cumulative Performance LY using a area chart.
- Show the top 7 products using a stacked bar chart
- Performance sales per city using a stacked bar chart```
Select the fields to be shown. Others will be hidden. Drag and drop to rearrange the order.
• Image
• SKU
• Rating
• Price
• Stock
• Availability
• Add to cart
• Description
• Content
• Weight
• Dimensions