Forum Discussion
Dateslicer not counting correctly
Hi Anonymous,
When you build the relationship between power bi data model tables, these not-match records will be mapped at the 'blank' options. I'd like to suggest you create a complete calendar table and map other table fields with 'star schema'.
Understand star schema and the importance for Power BI - Power BI | Microsoft Docs
In addition, since you are working with 'direct query' mode that has limited the Dax function usage for creating calculate column/table, you may need to create this table at your datasource side.
Regards,
Xiaoxin Sheng
Hi and thanks for your response! I managed to solve this with a little DAX altering in my measures and some small modifications in my model. I had unfortunately not the chanse to create the column ay my datasource side but the workaround is working perfectly. Thanks for helping out.