Now that you have completed your first calculated column, let's build a calculated column that stores the month–year value. The goal is to return a month–year column with the two-digit month and four-digit year separated by a dash, making "MM-YYYY". Let's build this calculation incrementally.
Select the Date (order) table and then click New Column from the modeling ribbon. Write the following code in the formula bar and then hit Enter:
Month Year = 'Date (Order)'[Month Number of Year]
As you begin validating the code, you will notice that this only returns the single-digit month with no leading zero. Your next attempt may look something like the following:
Month Year = "0" & 'Date (Order)'[Month Number of Year] ...
