Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!!
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |