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.
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:
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?
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