Matrix total

Anonymous: 
Create a date dimension table and use the columns from that table in your visual instead of the date columns from the fact table.
You can use this code for the calculated table:

Date = 
GENERATE (
    CALENDARAUTO (),
    VAR Yr = YEAR ( [Date] )
    VAR Mn = MONTH ( [Date] )
    VAR Qr = QUARTER ( [Date] )
    VAR MnQ = Mn - 3 * (Qr - 1)
    VAR Wd = WEEKDAY ( [Date], 2 )
    RETURN ROW (
        "Year", Yr,
        "Year Quarter", FORMAT ( [Date], "\QQ-YYYY" ),
        "Year Quarter Sorting", Yr * 100 + Qr,
        "Quarter", FORMAT ( [Date], "\QQ" ),
        "Year Month", FORMAT ( [Date], "MMM-YYYY" ),
        "Year Month Sorting", Yr * 100 + Mn,
        "Month", Mn,
        "Day of Week", Wd,
        "Week Day", FORMAT ( [Date], "dddd" )
    )
)

      

Showcase Report – Contoso By SpartaBI