Forum Discussion
Assistance with date table relationships
You do not have sales for every date. So your date table has all dates available, and your sales table will have dates for all days with sales.
Please mark it as a solution or give a kudo if it works for you, otherwise let me know if you run into an issue and I'll do my best to assist.
Thanks,
Hi Ryan,
I realise that I don't have sales for every date, but if you look at the pictures there are lots of sales orders that should have dates next to them when I used the dates generated from the Date Table.
Do you have an idea as to why this might be the case?
Can you add measures such as Min(Sales[Date]),Max(Sales[Date]),Min(Dimdate[Date]),Max(Dimdate[Date])? I would make sure your Date Dimension tables have enough dates to cover the dates in the Sales column.
The other common mistakes I see are not marking the date table as a Date table and sometimes having the date field formatted as a text field.
If you can attach some more screenshots, and maybe just use the actual date from the date table rather then the hiearachy I'll be better able to assist.
Please mark it as a solution or give a kudo if it works for you, otherwise let me know if you run into an issue and I'll do my best to assist.
Thanks,