Forum Discussion
Matrix
Hi, I want to create the below table in PowerBi, and I am using a Matrix for it: I have a table that holds all the Titles and the values that should be reported every month. I also have ...
HI RUION,
After test, I found this issue caused with your calendar table. It lost two month records so condition can't find out correspond records based on current calendar date.(max calendar date month is less than exited bucket table date)
When I test with full calendar with thirty-six records, it works well on total level.
Regards,
Xiaoxin Sheng
Hi Xiaoxin,
The totals for columns are now correct (after correcting the calendar table, as you suggested). But the totals on rows are still incorrect and I can see the same issue in the screenshot you sent. Any ideas on how to fix that?