YoY Calculations

Hi,

Try this

1. Create a calendar table by using the following formula under Modelling > New Table

=CALENDAR(MIN('Order Line'[Created Date]),MAX('Order Line'[Created Date]))

1. Create a relationship between the Created Date column of the Order Line table to the Date column of the calendar table
2. In the calendar table, create colums for Quarter, Month, year etc.
3. In the visual, drag the time period (Year or quarter or month) from the Calendar Table
4. Write these measures:

MM Total Revenue All Time = SUM('Order Line'[Total Revenue])

MM Total Revenue Last Year Calc = CALCULATE([MM Total Revenue All Time],SAMEPERIODLASTYEAR(Calendar[Date]))

MM Revenue YoY Change = DIVIDE( [MM Total Revenue All Time] - [MM Total Revenue Last Year Calc] , [MM Total Revenue Last Year Calc])

Hope this helps.