Months and Trailing Twelve Months in One Table
Use a disconnected table in Power BI to show each month and total trailing twelve months (TTM), the total for prior TTM, AND the variance between the two in one matrix table. Why? I saw a request for this kind of report in the Power BI Community forums. The requester also wanted the totals row to show the average for each column and to have conditional formatting for each cell, based on being above or below average.