Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
User | Count |
---|---|
118 | |
66 | |
65 | |
56 | |
50 |
User | Count |
---|---|
182 | |
85 | |
67 | |
61 | |
53 |