Forum Discussion
Wrong calculation
Hi Anik ,
Your Date dimension relates to the delivery date key field in Fact table, and you do have records with blank delivery date in the fact table. This is why the dimdate field is empty, and power bi won't filter them out by default in case you need them!
If you want to avoid that, you could add a filter on the visual/page/report to exclude those cases.
Anik Try using Invoice Date Key instead to form your relationship. You have blanks in your Delivery Date Key.
Hi Anonymous and Greg_Deckler , the left image was taken from a book, the right one was done by me. I tried and inspected everything according to my knowledge. I am sure I cannot hammer on the right place due to my inexperienced eyes. I have attached the practice file. Could you please go it over and tell me what's the mistake I made so that I don't make the same mistake over and over again? Thank you 😊 https://drive.google.com/file/d/1qFkzdEYZw3PffdZz3yngv5xluowB4TF5/view?usp=sharing
Hi,
In the Delivery Date key column of the Fact sales table, there are some blank cells. Plug them in with Dates.
Hope this helps.
Anik Try using Invoice Date Key instead to form your relationship. You have blanks in your Delivery Date Key.
Hi Greg_Deckler , Arentir , thank you so much 😊. Next time I am going to keep in mind about the blank cells while making relationships.
