RELATED Function shows empty

[Amymai]

Hello guys,

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

[v-yulgu-msft]

Hi @Amymai,

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.

Best regards,

Yuliana Gu

[Anonymous]

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.