Migrate from Power BI

table Sales
	column OrderID
		dataType: int64
		isKey
		sourceColumn: order_id

	/// Date the order was placed
	column OrderDate
		dataType: dateTime
		sourceColumn: created_at

	column Status
		dataType: string
		sourceColumn: order_status

	/// Total revenue in USD
	measure 'Total Revenue' = SUM('Sales'[Amount])
		formatString: \$#,0.00

	/// Revenue from shipped orders only (filter context)
	measure 'Shipped Revenue' =
			CALCULATE ( [Total Revenue], 'Sales'[Status] = "shipped" )

	/// Share of revenue that shipped
	measure 'Shipped Revenue %' =
			DIVIDE ( [Shipped Revenue], [Total Revenue] )
		formatString: 0.0%

	/// Year-to-date revenue
	measure 'Revenue YTD' = TOTALYTD ( [Total Revenue], 'Calendar'[Date] )

source: orders is conn.table('sales.orders') extend {
  primary_key: order_id
  join_one: customers is conn.table('sales.customers') on customer_id

  dimension:
    #(doc) Date the order was placed
    order_date is created_at::date

    #(doc) Order fulfillment status
    #(index)
    status is order_status

  measure:
    #(doc) Total revenue in USD
    # currency
    total_revenue is sum(amount)

    #(doc) Revenue from shipped orders only
    # currency
    shipped_revenue is sum(amount) { where: status = 'shipped' }

    #(doc) Share of revenue that shipped
    # percent
    shipped_revenue_pct is shipped_revenue / total_revenue

  view:
    #(doc) Year-to-date revenue — cumulative by month
    revenue_ytd is {
      group_by: order_date.month
      aggregate: total_revenue
      calculate: running_total is sum_cumulative(total_revenue) {
        partition_by: order_date.year
        order_by: order_date.month asc
      }
    }
}