Data modelling

[rutujakadam_11]

I have a DIM_CALENDAR table in Power BI which is the master data for all dates from year 2020 to 2025. I am creating a relationship between this Dim_Calendar table with Fact_Sales table which has details of sales such as Invoice_Number, Invoice Date, Business_Unit,, etc. The relationship is created between Date column of Dim_Calendar & Invoice_Date column of Fact_Sales tables and is one to many. Few Invoice numbers are not matching with the relationship created due to which there is data discrepancy. Eg: Out of all the sales created on 1/4/2022, only the first one maps with Dim_Calendar table rest entries show blank. What is the cause for this error. I have also made sure that both columns have same data type & Date format.

In the below snap you can see that only the entry of INVOICE_NUMBER-241688 maps with Date column of Dim_Calendar, rest all show blank. 

[Anonymous]

Hi @rutujakadam_11 

Could you please provide more raw data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples? It would be helpful to find out the solution. You can refer the following links to share the required info:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PhilipTreacy]

Hi @rutujakadam_11 

Download example PBIX file with data shown below

I can't reproduce your problem.  With my sample data if it is set up correctly with a Calendar that is marked as a Date Table  and you have a relationship between the calendar and your dim table, it should look like this

Please supply your PBIX file or some sample data so I can check it for you.

Regards

Phil