Forum Discussion
Matrix - replace Total per row with Average
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 basi...
HI Anonymous,
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.
Regards,
Xiaoxin Sheng