Forum Discussion
Calendar Table
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 !
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 !