Forum Discussion
Date Bridge Table
Hi Anonymous
Can you try changing the Cross Filter direction to single on both relationships?
The Cross Filter direction set to BOTH can affect the other tables.Also how did you go about creating your dCalendar table? I would suggest creating an independant table. I do have a blog post explaining how to do this: https://gqbi.wordpress.com/2016/09/13/power-bi-how-to-easily-create-dynamic-date-tabledimension-with-fiscal-attributes-using-power-query/
I don't see why yours was any different to mine, but it seems to work. Thanks a lot for the blog very helpful.
Hi Anonymous
There are often things that are very small between what is different and can be hard at times to see.
Hi GilbertQ
I have noticed that week of the year number is incorrect. The second week of the year starts on second row 2/01/2017 when it should start on the 9/01/2017.
Start year paramater is 2017 and fiscal start month is 7.
Not sure what has cuased this to be incorrect.
Cheers