Forum Discussion
Solved
Add records for missing dates into the table
Hi! Could someone help to fix this calculation or provide an advice? There is a large table Production that has Date, Model, Part columns (among others). There is a measure TakeRate that calculates ...
It turned out that when I do not include 'Date'[MonthDate] into SUMMARIZE, it works and aggregates as it should.
Fowmy
Super User
Super Userolexi
I am not sure how the measures [Plan] and [RakeRate] are constructed but to create all combinations including the missing dates you can try using the either CROSSJOIN or GENERATE functions within your measure.
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂