Creating a Calculated Column when Making a Table

Hi MichaelG1117 , 

Based on your description, Please try code as below to create a Calculated Column.

My Sample:

Table = 
var _table=
ADDCOLUMNS(
    CALENDAR(DATE(2013,1,1),DATE(2013,1,31)),
    "Weeknum", WEEKNUM([Date]),
    "Week Number & Year", "W" & WEEKNUM([Date]) & " " &YEAR([Date]),
    "WeekYearNumber", YEAR([Date]) & 100 + WEEKNUM([Date])
    )
return
ADDCOLUMNS(
    _table,    
    "Total Order Amount",
    SUMX(
    FILTER(ALL(Orders),
    'Orders'[OrdeDaterKey]=EARLIER([Date])),[OrderQuantity]*[SalesPrice])
    )

Result is as below.

Best Regards,
Yulia Yan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.