Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Date Table Link Issue with Data model

Hello Team,

 

I am running into a strange issue with the data model linkage. I created a Calendar table based on custom code and linked the dates from all of my dimension tables, so that we can query the data based on dates. Below is the screenshot:

 

 

I am trying to pull the date from Calendar table and generate the data, I am unable to see the distribution of dates. Can someone suggest what maybe missing here?

 

Please note: I transformed the date column for all dimension tables to DATE datatype in TRANSFORM DATA section.

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , This means

    1. Calendar does not have all dates

    2. You fact table dates have timestamp. Which are not visible because of datatype and format( Make it DateTime with the format having time, you will see time other than 12:00 AM)

     

    Create Date like

    Date = [datetime].date
    or
    Date = date(year([datetime]),month([datetime]),day([datetime]))

     

    In power Query

    DateTime.Date([datetime])

     

    Why Time Intelligence Fails - Power bi 5 Savior Steps for TI: https://youtu.be/OBf0rjpp5Hw

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Amit,

       

      I have the Calendar table with continuous dates and they are of date format. I made sure all the fact tables are of the same datatype date to ensure no differences come across.

       

      Any idea what could be the reason behind not linking still?

       

      Regards!

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    Maybe you can change your directions of all relationships from single to both. 

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.