Forum Discussion

KushGupta123's avatar
KushGupta123
Frequent Visitor
3 years ago
Solved

Date Table not working

I created the data table using "List.Dates(#date(2022,1,1),365,#duration(1,0,0,0))". I connected the date table to the table I wanted to filter. Both of them have same data types and same date format...
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi KushGupta123 ,

     

    DimTable:

    FactTable1:

    FactTable2:

    relationships:

     

    1. Please check that each value in the date column of the fact table can be found in the dimension table.

     

    2. If the date column in the fact table is of type date/time and the time part is not 12:00:00AM, although the relationship is displayed normally, it cannot be filtered correctly.

    You might consider creating another column of dates in the fact table to connect to the dimension table.

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

KushGupta123's avatar
KushGupta123
Frequent Visitor
3 years ago

HotChilli I tried doing it by putting date from dim_date table and dttm from my fact table and got a strange view

 

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi KushGupta123 ,

 

DimTable:

FactTable1:

FactTable2:

relationships:

 

1. Please check that each value in the date column of the fact table can be found in the dimension table.

 

2. If the date column in the fact table is of type date/time and the time part is not 12:00:00AM, although the relationship is displayed normally, it cannot be filtered correctly.

You might consider creating another column of dates in the fact table to connect to the dimension table.

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum