The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 empty
Formula to create date table
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
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.