Forum Discussion

jaryszek's avatar
jaryszek
Icon for Super User rankSuper User
9 months ago
Solved

Date Slicer Returns Blank Results When Using Dim_Date to Fact Monthly Costs

Hello everyone, I’m working with a model where Dim_Date contains a daily date column (e.g., 01-03-2025). My fact table (Monthly_Costs) is connected to Dim_Date using a 1-to-many relationship (D...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    9 months ago

    jaryszek 

     

    Updated: Download example PBIX file

     

    Add a column to your date table that is the first of the month for each date e.g.

     

     

    Then use that First Date column in the date slicer.  It will work fine with your month slicer, which is presumably getting the month from the same date table.

     

     

     

     

     

     

     

    Phil

Chewdata's avatar
Chewdata
Icon for Responsive Resident rankResponsive Resident
9 months ago

Hey!

First can you check if your dimtable date column is of the date or datetime type? 
Sometimes if the dim datetable has datetype as it's main date column (so 04-12-2025 00:00:00 instead of 04-12-2025) It won't match correctly.

 

 

  • jaryszek's avatar
    jaryszek
    Icon for Super User rankSuper User
    9 months ago

    There is the match. But designing it like that just can not work...because when user will select 2025-02-02 Month does not have a value like that becuase key is only 2025-02-01 (so first day in a month). 

    I could add per each month record specific Date buty it would increase table by 30 times...(per each day).

    Best,
    Jacek