Forum Discussion
DATES Table - relationship not working completely
Resident RockstarHi Anonymous,
Have you solved your problem?
If you have solved, please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.)
Best Regards,
Cherry
Hi all,
I uploaded pics with what I've done, hope they are visible:
- how I created the Month-Year Name column inside the dSales table.
- the resulting column based on the above
- the date table I created and the resulting Month-Year Name column I use to create a relationship between this date table to the dSales table
- the relationship from MonthTable (or date table) to dSales table (based on Month-Year Name column)
- visual based on order count from dSales table and Month-Year Column from dSales - it counts for each month
- visual based on order count from dSales table and Month-Year Column from MonthTable - doesn't see any month count.
Thanks a lot!