07-23-2018 12:43 AM
I have checked the Date table and Sales table as well. I'm not sure where I'm missing. Can you please help me on this.
07-23-2018 01:07 AM
Have you checked the YTD-MOD pbix file I shared? As my previous post, your date table doesn't contain all the possible date values of your sales table. Please change your Date table to the following:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
10-15-2018 06:34 PM
hi I am doing the right relationship and all the dates are popping in the datedim but when I create a table with both the relationship dates I get null in datedim column can you plz help me?
10-15-2018 06:45 PM
The datedim is a table created using DimDate = CALENDAR("1/1/2008","12/31/2020") and submit date is a another column in other table with duplicate dates. The relationship is both ways between the two column in spite of it when I try creating a table between the 2 columns I get null values for dimdate column