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.
I have a question regarding the following 3 tables which appear in the image below:
- Resources table (It contains a date field ("hire_date").
- ProductsResources table (it contains two date fields ("start", "end").
- Date table (Generated from CALENDARAUTO function)
As you can see, the relationship between the Date and ProductsResources tables is inactive, also this inactive relationship is only between the "date" and "end" fields, I can't create a relationship between the "date" and "start" fields.
I have the two visualizations below which show that the date table works correctly only with the Resources table (the one on the right).
What should I do instead to make everything works?
Hi @MontherKH ,
you can use USERELATIONSHIP formula which will utilise your inactive relationship when that measure will run.
Could you please specify what you need so that I can provide you with a solution.
Please do gives a thumbs up if it helps you
Regards
Dark
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 |
---|---|
106 | |
105 | |
88 | |
75 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |