Forum Discussion

Amymai's avatar
Amymai
Frequent Visitor
7 years ago

RELATED Function shows empty

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

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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.  

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    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