Forum Discussion
stino123
Helper II
Helper IIFact table is not working with Calendar table
HI, I have the following relationship between my calendar table and my fact table which demonstrates number of visitors. Both the data types are date/time, I have played around with the types wit...
Hey amitchandak, I managed to find the solution. It seems that when I changed the type of data in my fact table in the table function on desktop it did not work. However in Power query by changing the date table in my fact table from date/time to date the relationship did work. Thanks for the help though
stino123Helper II
Helper IIHey amitchandak, I managed to find the solution. It seems that when I changed the type of data in my fact table in the table function on desktop it did not work. However in Power query by changing the date table in my fact table from date/time to date the relationship did work. Thanks for the help though