Forum Discussion
Tables - incomplete months - calculation issues
Super UserHi RobinIrving
It would be easiser for us to understand what you're trying to achieve if you provided a workable sample data (not an image), your expected result from that same data and the reasoning behind. You may post a link to a sanitized copy your pbix or an excel file stored in the cloud.
That aside, here's the clude why they don't appear even if you add zero or use colesce
This works fine for all resources however anyone with no rows for a month still show up as blank in my matrixbecause you can't assign a value to a row that doesn't exist. So if employee A has data only unitl June and you use the same column, employee A will show data only until June. This is one of the reasons why we use a separate dimensions table containing a complete set of dates (even the future ones) so values can be assigned to them. Otherwise, you will have to append some dummy future dated rows for each employee into your data just to make up for the missing ones which is another way to slow down data refresh.
Thanks for mentioning the dummy option - I managed to get that working well with a bit of fiddling. With this level of data it works fine.If I ever need anything more I will worl out a way to be able to provide a cleansed PBIX for you all to look at. Cheers
Hi RobinIrving,
In fact, You only need to remove the sensitive data from the table records or tried to replace them to dummy values.(e.g. abc, test123)
Regards,Xiaoxin Sheng
Hello,
Yes I decided to go with the dummy rows for each month as a solution. Still got a few issues with this as some of the resources have multiple rows for themselves and also there are quite a lot of them with issues swith the way they have been set up as well. Rather comlicated but geting there.
Happy to class the creating duplicate month rows as a solution.
Cheers