A matrix typically will list totals at collumn and row level. In order to better analyse monthly variances, I would like to compare the lastest month's numbers with the YTD monthly average. So I basically would like to see an "Average" column rather than a "Total" column as per below. The column totals in the bottom row can stay. Is this possible?
Yes, it is possible. You can add if statement to check total level and write a specific formula for calculation of total level, then use condition to replace calculation on total level with that formula.
If you are confused on coding formula, please share some sample data or pbi file that we can test and coding formula on it.
Community Support Team _ Xiaoxin If this post helps, please consider accept as solution to help other members find it more quickly.