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 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