Forum Discussion

Marian1981's avatar
Marian1981
Advocate II
2 years ago
Solved

Calendar Table

Hi All !  I've got three fact tables will their own date column and I've created a calendar table in order create a relationship between the tables based on that. When using now the date field from ...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • Marian1981's avatar
    Marian1981
    2 years ago

    Hi manvishah17 !

    I think I found what the problem was but the data is loading just now on the desktop and can't confirm.

    I was changing the data type of the date columns on the desktop, but when I checked in the power query they were having different type. So I changed it in the power query to match on each table including the calendar and now I am waiting on the data to load. 

    Also, I though MARK AS DATE TABLE, is not necessary for the relationship to work ? Unless I need some time intelligence calculations. I will let you know if what I did worked. 

     

    Cheers !

manvishah17's avatar
manvishah17
Solution Supplier
2 years ago

Hi Marian1981 ,
Please check datatype of all your date columns whether they are date or not? 
Second mark your datetable as MARK AS DATETABLE. 
If this not resolve your query please do share your sample file.