Forum Discussion
Missing datapoints in date-based measure
I defined some DAX measures in Excel 2013 based on a facttable with dates linked to a date table. All measures correctly show their value by month (from the date-table) in a Powerpivot. I import ...
I found the issue: the date table in Excel was corrupt. I could only select the columns in the fact table as unique identifiers for the date column (?)
Rebuilding the date table from scratch solved the problem.
MattAllington
Community Champion
Community ChampionWell I guess it is either a bug, or it isn't. The challenge is to find out which. I would be happy to take a look if you can share with me. You can contact me via my website http://xbi.com.au or you could log a bug with MS
I found the issue: the date table in Excel was corrupt. I could only select the columns in the fact table as unique identifiers for the date column (?)
Rebuilding the date table from scratch solved the problem.