Thanks for this example. These are much appreciated as I work to learn PowerBI.
I've followed your tutorial with my own SQL data using our dimDate table. However when I add the Month, Quarter and Year totals, the totals don't sum to date like your example shows they should. They all show the same value as the month (see attachment). I've checked my Measure formulas and they are using their respective functions for Month, Quarter and Year to date
MonthSales = TOTALMTD(SUM(grossSales[Amount]), dimDate[dateKey])
QuarterSales = TOTALQTD(SUM(grossSales[Amount]), dimDate[dateKey])
YearSales = TOTALYTD(SUM(grossSales[Amount]), dimDate[dateKey])
What have I missed?