Here is the thing that I can't understand why it didn't work. It's not supposed to be like that. Please help me!!
Relationship one to many
Related function shows emptyFormula to create date table
can you share your file? I used your function for calendar and was able to get related to work using the World Wide Importers database. So there's something going on in your file.
I also made the assumption that your MonthOfYear is a calculated column.
In my test, the RELATED function could return expected result, unless the data type of [Date & Time] in 'Sales Data' table is set to Text rather than Date/Time.
If that is not your case, please share your sample .pbix file for test.
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.