Forum Discussion
Dates mess
- 7 years ago
Anonymous
Adding a relationship between tables and creating calculations using those relationships will solve this issue. Here is a group of relationship blogs to help.
https://powerpivotpro.com/category/skill-areas/relationships/
Anonymous
Thanks for the detailed explanation!
Now check whether Date Table you created have dates from previous months (This is most important and basic).
https://1drv.ms/u/s!Ah0UhoGdkH5biiOjPbQ82ZBihJZY?e=K3ymgI
This is what I tried, and I am getting it correct! Let me know your findings.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Thanks agan. I see it works in your file. but mine is still blank. So it needs to be a fundemental error somewhere.
My dates table: