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.
Hi, I'm trying to build a relationship for these 2 date columns from different tables. But seems that I'm keep getting this message.
Any solution for this?
@Anonymous
Please, before you start modeling in PBI, get familiar with the philosophy behind this tool. Otherwise you'll be constantly shooting yourself in the foot. You can start here: Model relationships in Power BI Desktop - Power BI | Microsoft Docs
@Anonymous , You need to create a common date table and join both tables with that and you can use columns from date table for filters
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
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 |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |